DATE GDP
1/1/2012 16155.255
1/1/2013 16691.517
1/1/2014 17427.609
1/1/2015 18120.714
1/1/2016 18624.475
Hi, Everyone. This is the data I have, But I would like to transfer it to monthly data in SAS. For example, I can have GDP of 1/1/2012, 2/1/2012...12/1/2012. I know how to do this in Eviews software. But I have no clue how to do it in SAS. Would you mind helping me?
If you have a SAS/ETS licence, use proc expand:
proc expand data=gdp out=mgdp from=year to=month;
id date;
run;
This will give you a spline interpolation. For a linear interpolation:
proc expand data=gdp out=mgdp from=year to=month method=join;
id date;
run;
If you have a SAS/ETS licence, use proc expand:
proc expand data=gdp out=mgdp from=year to=month;
id date;
run;
This will give you a spline interpolation. For a linear interpolation:
proc expand data=gdp out=mgdp from=year to=month method=join;
id date;
run;
It works!
Thank you so much
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.
Find more tutorials on the SAS Users YouTube channel.