Hi Reeza,
Main reason for doing this is to have estimated yearly observations from the census data which is only estimated by 10 year period.
Best,
Markov
I figured that out, but why do you need annual data. Linear interpolation from a statistical standpoint may not be a valid interpolation method for what you're trying to do is my point.
Valid point and thank you for pointing this out Reeza. I am just in a trial phase: the primary variable in interest is in annual basis & figured that some of literature have adopted linear interpolation for socioeconomic variables.
Thanks,
Markov
Hi there, I am trying to do the same thing as this user -- do a linear interpolation. However my data are semi-annual and I want to go to a monthly frequency. I have three reported periods: Dec. 2014, June 2015 and Dec. 2015 with the remaining months in between to be generated. I have attached a screenshot of the data.
I tried modifying code in this thread but no luck.
I am new to this so any help greatly appreciated.
Thanks
Jack
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.