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

Hi,

 

I want to see how sensitive of each variable to a response variable in percentage for a time series model generated by an ARIMA procedure in SAS/ETS, for instance, I have a model as follows:

 

Y(1) = AR(1) + MA(1) + aX + bZ + cR,

 

where Y(1) is a first-order difference term of the response variable, AR(1) is a first-order autocorrelation term,  MA(1) is a first-order moving average term, and X, Z, R are the predictor variables in the model.

 

Each of them has its own coefficient, and I want to see the percentage change of the response variable while each predictor variable changes for 1%, for instance,  

 

Variable Sensitivity- Impact of One Point Change on Y(1)

Predictor Variable

Sensitivity

 

   

AR(1)

30%

   

MA(1)

1.5%

   

X

-19%

   

Z

-11%

   

R

-30%

   

 

How can I generate this kind of table for a time series model in SAS/ETS?

 

Thank you for your help!

 

Lawrence

1 ACCEPTED SOLUTION

Accepted Solutions
user24feb
Barite | Level 11

Not sure, if I understood you correctly:

ODS Output ParameterEstimates=Est;
Proc ARIMA Data=A;
  Identify Var=x CrossCorr=(y z r);
  Estimate p=1 q=1 Input=(y z r);
Run;
ODS Output Close;

Data Sensitivity1Pct (Keep=Parameter Variable Sensitivity);
  Set Est;
  Sensitivity=Estimate*0.01;
Run;

View solution in original post

2 REPLIES 2
user24feb
Barite | Level 11

Not sure, if I understood you correctly:

ODS Output ParameterEstimates=Est;
Proc ARIMA Data=A;
  Identify Var=x CrossCorr=(y z r);
  Estimate p=1 q=1 Input=(y z r);
Run;
ODS Output Close;

Data Sensitivity1Pct (Keep=Parameter Variable Sensitivity);
  Set Est;
  Sensitivity=Estimate*0.01;
Run;
LawrenceYu01
Fluorite | Level 6

Thank you!

 

After you got the data set Sensitivity1Pct how do you estimate the effect of a change of an independent variable on the dependent variable while keeping all the other terms fixed?

 

Thank you for your help!

 

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