BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
putteringpluie
Obsidian | Level 7

I have census data from 2001 and 2011. I want to interpolate all the variables for the in-between years by simple linear function. I don't want to use proc expand because of its constraint that slope will be zero in the beginning and end values. Any suggestions?

 

  proc expand data=have out=want;
by state;
id year;
run;

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

PROC REG or a linear regression type models? That's still going to be a hell of a lot of variables and the assumption of constant growth isn't correct either. 

View solution in original post

4 REPLIES 4
Reeza
Super User

PROC REG or a linear regression type models? That's still going to be a hell of a lot of variables and the assumption of constant growth isn't correct either. 

putteringpluie
Obsidian | Level 7

Thank you for such a quick reply. I was wrong about the assumptions in proc expand. The slope need not be zero. 

Reeza
Super User

PROC TIMESERIES will also fill in missing time with several options. 

ballardw
Super User

@putteringpluie wrote:

I have census data from 2001 and 2011. I want to interpolate all the variables for the in-between years by simple linear function. I don't want to use proc expand because of its constraint that slope will be zero in the beginning and end values. Any suggestions?

 

 


If this is US Census bureau data I would recommend using the annual estimates that are available. I doubt if anything the Census works with actually has an 11-year straight line trend except the year variable.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 885 views
  • 3 likes
  • 3 in conversation