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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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