reading data and frequency conversion

[wags]

I apologize in advance for posting what I hope is a simple question. I am using EViews for the first time in more than a decade and I have not been able to figure this out.

I have data on two worksheets in Excel; one worksheet contains quarterly data and the second contains monthly data. I would like to have a program that (a) creates the workfile and (b) reads in the data from both worksheets with the frequency conversion from monthly to quarterly. All of the data also need to be on the same page in the workfile.

Is there a way that this can be done? I've attached a sample data file and my program, which obviously does not automatically convert the monthly data to quarterly.

I am also using EViews 8 if that matters.

Thanks a ton for any help you can provide.

create_workfile.prg

(215 Bytes) Downloaded 264 times

example.xlsx

(16.61 KiB) Downloaded 304 times

[EViews Gareth]

You just need the WFOPEN and IMPORT commands.

[wags]

Thank you!