BookmarkSubscribeRSS Feed
chemicalab
Fluorite | Level 6

Hi all,

I am facing the following problem: I have complete series for Y and X1 X2 X3 only for a period of 11 months (not enough to fit a model and to give good forecasts).

I could obtain an additional 12 month period back in time, only thing is i dont have any info about Y but the info for  X1 X2 X3 is there.

What would be the best way to impute values for Y?

Thanks in advance

1 REPLY 1
udo_sas
SAS Employee

Need to edit my suggestion - as I only realized now, that you don't have any previous values for Y at all (note to self: reading skills are a plus).

In this case my suggestions below won't work of course.

Hello -

Time series models typically deal with missing values well, if there are only few. So you might want to try your data as is first.

As another idea, you may want to use an exponential smoothing model for your Y series first, and use its predictions to impute missing values of Y.

Thanks,

Udo

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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
  • 1 reply
  • 1121 views
  • 0 likes
  • 2 in conversation