converting incremental monthly series to quarterly

[spradhan]

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]

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.

[spradhan]

Hi Gareth,

thank you so much for this help :D