Seasonal adjustment daily/hourly data

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

pablete
Posts: 7
Joined: Wed Mar 02, 2011 5:10 am

Seasonal adjustment daily/hourly data

Postby pablete » Wed Mar 02, 2011 5:55 am

Is there any way to perform an automated seasonal adjustment (like X12, tramo/seats ...) with hourly or daily frequency data? If not can anyone provide some advice on how to acomplish this (in a non-automated way)? (hopefuly in EVIEWS)

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

Re: Seasonal adjustment daily/hourly data

Postby EViews Gareth » Wed Mar 02, 2011 9:08 am

There isn't anything built in that will do it, since hours don't really have "seasons". The manual goes into detail on how the moving average seasonal adjustment techniques are calculated. There is no reason why you could not extend these to any other frequency, as long as you can decide upon the length of a "season". As a starting point. I've written the following program that computes the moving average seasonal adjustment for a monthly series using the built in procedure, and then computes it manually following the formulas in the manual:

Code: Select all

create m 1990 2000 series y=rnd y.seas(m) y_seas series x = @movav(y(6), 12) series r = y/x !product=1 for !m=1 to 12 smpl if @month=!m series i!m = @mean(r) !product = !product*@mean(r) next !product = !product^(1/12) for !m = 1 to 12 smpl if @month = !m series s = i!m / !product next smpl @all series ysa = y/s show ysa y_seas 'delete i* r s

pablete
Posts: 7
Joined: Wed Mar 02, 2011 5:10 am

Re: Seasonal adjustment daily/hourly data

Postby pablete » Thu Mar 03, 2011 3:43 am

Thanks a lot!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests