Is it possible to use proc expand to extrapolate missing values at the beginning of the period? I have an annual variable with data from 1993 to 2016 and will like to complete the missing values from 1990 to 1992
Any help will be appreciated
Maria
If you want a more model based extrapolation of earlier values, you could use PROC SSM (also in ETS). See an example in the doc:
Example 34.3 Backcasting, Forecasting, and Interpolation in http://support.sas.com/documentation/onlinedoc/ets/indexproc.html#ets143
(go to the SSM chapter).
Yes, as long as the method makes sense. PROC TIMESERIES does a good job at this. What is the algorithm you want to use to fill in the earlier values?
See the SAS PROC TIMESERIES documentation for the options, under the ID statement and SETMISSING.
They include:
MISSING
Missing values are set to missing. This is the default option.
AVERAGE | AVG
Missing values are set to the accumulated average value.
MINIMUM | MIN
Missing values are set to the accumulated minimum value.
MEDIAN | MED
Missing values are set to the accumulated median value.
MAXIMUM | MAX
Missing values are set to the accumulated maximum value.
FIRST
Missing values are set to the accumulated first nonmissing value.
LAST
Missing values are set to the accumulated last nonmissing value.
PREVIOUS | PREV
Missing values are set to the previous period’s accumulated nonmissing value. Missing values at the beginning of the accumulated series remain missing.
NEXT
Missing values are set to the next period’s accumulated nonmissing value. Missing values at the end of the accumulated series remain missing.
If you want a more model based extrapolation of earlier values, you could use PROC SSM (also in ETS). See an example in the doc:
Example 34.3 Backcasting, Forecasting, and Interpolation in http://support.sas.com/documentation/onlinedoc/ets/indexproc.html#ets143
(go to the SSM chapter).
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 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.