Cross-section frequency conversion

[ewijks]

Dear ,

I am working with a large panel dataset, in which I need to perform a high to low frequency conversion, not in the time dimension, but in the cross-section.

Thus, one workfile page has the following dimensions: 2001 2010 x 111,000 or around 800,000 observations
The cross-section identifier here is off, which is a unique number for specific offices. The page also contains a series called inst, which matches the offices with the institutions to which they belong.

The other workfile page has the following dimensions: 1992 2010 x 16,000 or around 190,000 observations.
The cross-section identfier here is inst ,and corresponds to inst in the first workfile page.

I need to paste series from the first page in the second page.
Date should just be matched (both workfile pages are annual, the only difference is that the date series of first workfile page contains June dates, e.g. 2003-06-30, and the date series of the second workfile page contains year-end dates, e.g. 2003-12-31), but there should be a conversion of the cross-section from high (off) to low (inst) frequency.
Key to matching the data correctly is inst, which is contained in both workfile pages.

Is this possible?
And if yes, how do I do it?

I am looking forward to your response, thank you in advance.

Best regards,
Saskia

[EViews Gareth]

It should work by simply copying, and then pasting, using "paste special", and setting @date and inst as your two destination and source IDs.