A noob question

[Kavorka]

Dear all,
This is of course a noob question (which I should solve but I did not get why I did not get it right...). Thus, please submit a "for loop" link when UNDATED (according to EViews) but in fact QUARTERLY data is aggregated to ANNUAL data (so it needs to be summarized for 4 quarters in order to provide one annual observation).

For certain reasons, and since this is a simulation example that I want to show to my students, I want to use UNDATED data (and not dated quarterly to annual data which is very easily converted to annual data). E.g. for a data set like this: wfcreate undatedfile u 1000

In summary, I just want to have a frequency conversion from quarterly to annual data (for a data set where I in EViews have defined the data as undated). Please provide a SYNTAX for this tranfer.

Best regards
/P

[EViews Gareth]

Sorry, I don't understand the question.

[Kavorka]

I add an excel example of what I mean.

Basically I want to make a frequency conversion from quarterly to annual data with syntax, but where the data is undated like this

Code: Select all

wfcreate undatedfile u 1000

I hope this explains what I ask for.
/P

[EViews Gareth]

You can use the general match merge copy interface, using the date series on each page as the id series.

[Kavorka]

Thanks for the answer but I do not want to use the interface (if I understand this correctly you refer to this interface http://www.eviews.com/Learning/freqconv_a.html e.g. at slide number 14). This is what I would like to do but not by this interface - instead solely by using syntax, since I will do it over and over again. /P

[EViews Gareth]

Use the copy command then.

[Kavorka]

I thought that I could do this using the EViews interface, and then save "Display Command Capture Window" and then use this syntax later (since I am only interested in the syntax).

In the
http://www.eviews.com/Learning/freqconv_a.html
I could only find examples for dated time-series data, not for undated data.

It works easily when I have dated data, but when I have this undated series (see the attachment where I generated 10000 quarterly integers in the Quarterly tab, and tries to convert this to 2500 Annual data observations based on e.g. the first quarter every year) - it does not work for me.

In the Quarterly page I copy the x variable.
I go to the Annual page
Right-click at the white area and chooses "Paste Special..."

Could you please help me with the following steps in order to convert the frequency from quarterly to annual data for x (still keeping the file undated without converting the entire file to a time-series file)? (I use EViews 9.5)

[EViews Gareth]

You need to have series containing dates.