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
converting incremental monthly series to quarterly
Moderators: EViews Gareth, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13307
- Joined: Tue Sep 16, 2008 5:38 pm
Re: converting incremental monthly series to quarterly
You'll have to do it in a few steps.
Where Y is the underlying series, and monthlypage and quarterlypage are your pages.
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
Re: converting incremental monthly series to quarterly
Hi Gareth,
thank you so much for this help
thank you so much for this help
Return to “General Information and Tips and Tricks”
Who is online
Users browsing this forum: No registered users and 14 guests