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
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!
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.