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

 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

1 ACCEPTED SOLUTION

Accepted Solutions
rselukar
SAS Employee

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

View solution in original post

2 REPLIES 2
Reeza
Super User

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.

 

http://support.sas.com/documentation/cdl/en/etsug/66840/HTML/default/viewer.htm#etsug_timeseries_syn...

 

rselukar
SAS Employee

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 2 replies
  • 748 views
  • 0 likes
  • 3 in conversation