Frequency Conversion

For requesting general information about EViews, sharing your own tips and tricks, and information on EViews training or guides.

Moderators: EViews Gareth, EViews Moderator

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Frequency Conversion

Postby EViews Gareth » Wed Aug 10, 2011 8:55 am

Could you provide more details?
Follow us on Twitter @IHSEViews

jason_ll
Posts: 43
Joined: Thu Sep 01, 2011 11:38 am

Re: Frequency Conversion

Postby jason_ll » Wed Oct 05, 2011 2:09 pm

Hi there,
I have a few variables in an Excel sheet. They are annual and my workfile is quarterly. Every time I import them, they get converted using the constant match (average) method. I keep trying to change the method (I want it to be linear), but no matter which frequency conversion option I choose, it always gets conveted according to the constant match method.

I even tried changing the default Eviews conversion, but it still doesn't work. It gives me data that looks like this:

2000Q1 30.29750
2000Q2 30.29750
2000Q3 30.29750
2000Q4 30.29750
2001Q1 25.92250
2001Q2 25.92250
2001Q3 25.92250
2001Q4 25.92250

I was only able to fix this problem in two steps. First copying the data into Eviews as it appears above, and then create a series link that converts it using the linear converstion. That did work, but it takes up too much time and I don't want to work with a "series link".

Thank you!

PS: I'm importing the data from Excel using the File -->import --> import from file method.
In step 3 out of 3, you get the option of choosing the conversion method. Btw, conversion has always worked flawlessly from high to low frequency, but now it doesn't seem to work the other way around.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Frequency Conversion

Postby EViews Gareth » Wed Oct 05, 2011 2:17 pm

Importing and performing frequency conversion only supports a couple of conversion methods from low to high. The dialog shows the full list of options available, but only constant match actually work :(
Follow us on Twitter @IHSEViews

jason_ll
Posts: 43
Joined: Thu Sep 01, 2011 11:38 am

Re: Frequency Conversion

Postby jason_ll » Thu Oct 06, 2011 6:03 am

EViews Gareth wrote:Importing and performing frequency conversion only supports a couple of conversion methods from low to high. The dialog shows the full list of options available, but only constant match actually work :(

That's strange. Thanks for the confirmation.

ewijks
Posts: 7
Joined: Tue Nov 16, 2010 2:36 am

Re: Frequency Conversion --> Cross-section frequency convers

Postby ewijks » Fri Dec 02, 2011 6:43 am

Hi Gareth,

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

atoch
Posts: 13
Joined: Wed Dec 02, 2009 2:54 am
Location: Paris, France
Contact:

Re: Frequency Conversion

Postby atoch » Tue May 29, 2012 3:18 am

Bonjour,

Thank you for this post on frequency conversion.
Setting them up seems very easy either with the link or copy commands.
I'm looking for an instruction to extract the conversion method used from objects that already exist in a workfile.
Ie: in an annual page, GDP is a link to a quarterly page. What is the command to retrieve if annual GDP was build as a sum or an average ?

Thanks.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Frequency Conversion

Postby EViews Gareth » Tue May 29, 2012 7:42 am

If it is a link, you can open up that link, hit the "Properties" button, and then look at the "Link Spec" tab to see which conversion method is being used.
Follow us on Twitter @IHSEViews

Fenix
Posts: 7
Joined: Fri Feb 04, 2011 10:52 am

Re: Frequency Conversion

Postby Fenix » Wed Jun 27, 2012 2:29 am

Hey!

Is there a way to have linear interpolation without using the last ovservation, just use average values?

I have annual data. I convert it to quarterly. If I choose constant-match average and paste it as a link I get just the annual values divided by four in the spreadsheet BUT when I graph it, I get a linear interpolation in the graph. I want exactly the linear interpolation. If I unlink the series, the graph changes to the stepwise one. I.e. is there a way to export the data from the graph (even thought it says it uses the Raw Data, it does not).

I tried the 'linear - match last' but it doesn't work for me.

More details: I have annual series for total population from 1999 to 2011. Year 1990 is 470'388'255. I want a simple linear interpolation, where the average of the values 1990Q1 to 1990Q4 is 470'388'255.
If I use " constant-match average " I get
1990Q1 = 470'388'255
1990Q2 = 470'388'255
1990Q3 = 470'388'255
1990Q4 = 470'388'255
BUT the graph does not look stepwise as long as I have the series as a link. So if I have a link, the graph looks like that what I want in the end but do not know how to get the data.

If I use 'linear - match last', then this is true for the average of 1990Q4 - 1991Q3 and in the end I am missing 3 observations, since the value for 2012Q1 is the value for the whole 2011.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Frequency Conversion

Postby EViews Gareth » Wed Jun 27, 2012 7:52 am

No, you cannot do that.
Follow us on Twitter @IHSEViews

iftikharferoze
Posts: 2
Joined: Sat Jul 21, 2012 1:10 pm

Re: Frequency Conversion

Postby iftikharferoze » Sat Jul 21, 2012 1:15 pm

I tried to do data converting from quarterly to monthly, but in the first two row of my data set was vanish. I just could see NA expression in that rows. what I need to do to get rid of this. I use version 5

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13294
Joined: Tue Sep 16, 2008 5:38 pm

Re: Frequency Conversion

Postby EViews Gareth » Sat Jul 21, 2012 1:24 pm

Hard to say without seeing the data.
Follow us on Twitter @IHSEViews

mylo47
Posts: 2
Joined: Thu Jun 28, 2012 11:27 am

Re: Frequency Conversion

Postby mylo47 » Wed Aug 08, 2012 1:07 pm

Hi
I noticed the following discrepancy in the conventions for frequency conversion. When I convert data from daily to monthly using, say, option c=l, EViews chooses the value from the last day of the given month. This is logical. However, when I convert data from daily to weekly (again, with option c=l), then EViews chooses the value from the last day of the following week, not of the given week. This is inconsistent with the monthly convention and is fraught with the danger of look-ahead bias in forecasting work. Is there a way to select the value from the given week in a systematic way? Also, any ideas what was the thinking behind this design?
Thank you

EViews Chris
EViews Developer
Posts: 161
Joined: Wed Sep 17, 2008 10:39 am

Re: Frequency Conversion

Postby EViews Chris » Wed Aug 08, 2012 1:50 pm

In all cases, 'last' should return the last high frequency observation that falls within the lower frequency observation.

My guess is that what is confusing you is the definition of the week. The week begins on whatever day you use as a start date and ends on the seventh day counting from that. EViews does not force weeks to start on any particular weekday.

You can use

show @strdate("weekday")

to see what day of the week each observation of your weekly workfile begins on.

And you can use

show @date @enddate

to see the range of dates within any observation.

Does that explain things?

mylo47
Posts: 2
Joined: Thu Jun 28, 2012 11:27 am

Re: Frequency Conversion

Postby mylo47 » Thu Aug 09, 2012 6:08 am

Chris
Thanks a lot for the explanation - this clears up the concept. Is there any way to redefine the week as the 7 days before a given day?
Cheers
George

EViews Chris
EViews Developer
Posts: 161
Joined: Wed Sep 17, 2008 10:39 am

Re: Frequency Conversion

Postby EViews Chris » Thu Aug 09, 2012 9:21 am

You'd have to shift the start date of the weekly workfile back by six days.

In a program you could do something like this:

series dateshift = @dateadd(@date, -6, "day")
pagestruct @date(dateshift)
delete dateshift

EViews always labels weekly observations with the beginning-of-period date in the spreadsheet view (the same value as the implicit series @date). We could provide an option for displaying end-of-period date in this view as well (the implicit series @enddate) - although I suppose that might confuse people even more if they weren't sure which one they were looking at. The unambiguous thing would be to display the full range from start date to end date all the time but that would take up a lot of screen real estate. Providing @enddate as an implicit series is a sort of compromise - it's there if you want to see it.


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 8 guests