## interpolating 100+ variables

Solved
Occasional Contributor
Posts: 9

# interpolating 100+ variables

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;`

Accepted Solutions
Solution
‎02-13-2018 02:23 PM
Super User
Posts: 23,771

## Re: interpolating 100+ variables

Posted in reply to putteringpluie

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.

All Replies
Solution
‎02-13-2018 02:23 PM
Super User
Posts: 23,771

## Re: interpolating 100+ variables

Posted in reply to putteringpluie

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.

Occasional Contributor
Posts: 9

## Re: interpolating 100+ variables

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

Super User
Posts: 23,771

## Re: interpolating 100+ variables

Posted in reply to putteringpluie

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

Highlighted
Super User
Posts: 13,583

## Re: interpolating 100+ variables

Posted in reply to putteringpluie

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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