Seasonal adjutment of multiple series

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

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

manthonisz
Posts: 9
Joined: Tue Nov 11, 2014 10:32 pm

Seasonal adjutment of multiple series

Postby manthonisz » Tue Nov 11, 2014 10:46 pm

Hi guys,

Wondering if someone knew how to seaosnally adjust multiple series at the same in EViews?

The User Guide gives instructions on how to do it for one series at a time but I have 50 series that I'd like to seasonally adjust all at once rather than doing each individually.

Appreciate any help you can give.

Regards,

Michael

econmiller
Posts: 17
Joined: Wed Nov 04, 2009 6:22 pm

Re: Seasonal adjutment of multiple series

Postby econmiller » Mon Dec 15, 2014 9:25 am

Michael, try something like this. Create a program file and run. This is probably not the most elegant solution, but it works for me.

group tmp * ' or create a list of 50 variables
%sname="d"
!counter=1
while %sname<>""
%sname=tmp(!counter) ' Variable name
{%sname}.x12(save "d11") {%sname} ' seasonally adjust series is {%sname}_sa
delete %sname ' delete unseasonally adj. series to replace with seasonally adj. series
{%sname}={%sname}_sa ' rename
delete {%sname}_sa ' delete extraneous series
!counter=!counter+1
%sname={%vt}(!counter,1) 'determine to exit based on next cell
wend


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 5 guests