converting incremental monthly series to quarterly

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

Moderators: EViews Gareth, EViews Moderator

spradhan
Posts: 8
Joined: Thu Sep 24, 2015 12:55 am

converting incremental monthly series to quarterly

Postby spradhan » Tue Jul 05, 2016 10:46 am

Hi,
I've incremental monthly series with value increasing for each month till M12.
Now for converting this series to quarterly, I need to keep Q1 value as it is for M03. Q2 = M6-M3, Q3=M9-M6 and Q4=M12-M09. Don't know how to create such series.
So, please let me know a function that will do this transformation.

Thanks,
Santosh

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

Re: converting incremental monthly series to quarterly

Postby EViews Gareth » Tue Jul 05, 2016 11:14 am

You'll have to do it in a few steps.

Code: Select all

copy(c=l) monlypage\y quarterlypage\y
smpl if @quarter<>1
y = y-y(-1)
smpl @all


Where Y is the underlying series, and monthlypage and quarterlypage are your pages.
Follow us on Twitter @IHSEViews

spradhan
Posts: 8
Joined: Thu Sep 24, 2015 12:55 am

Re: converting incremental monthly series to quarterly

Postby spradhan » Tue Jul 05, 2016 11:49 am

Hi Gareth,

thank you so much for this help :D


Return to “General Information and Tips and Tricks”

Who is online

Users browsing this forum: No registered users and 14 guests