BookmarkSubscribeRSS Feed
modelingfreak
Calcite | Level 5

Hi,

I am trying to create a financial forecasting model. The model is based on Simple linear regression. My problem is that some of the final variables in my model do not make as much economic sense as some of the other variables but these variables are coming out to be very significant. The other variables that are making economic sense are not explaining much of the R Square. What I want to do is first select the variables that are making economic sense and then add on the other variables in the model so that the previous varaiables do not get weeded out. I need a king of a wrapper around a set of variables so that it protects them from getting out of the model. Is there any statistical technique that could help.

Thanks

Prakhar

1 REPLY 1
DLing
Obsidian | Level 7

If you are using PROC REG for simple linear regression, the MODEL statement has an option called INCLUDE=n that will keep the first n variables listed in the model always while doing variable selection on the rest.

http://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_reg_sect013....

If you are willing to first determine the economic variables of interest, which sounds like you are, this option will allow you to force them into the model.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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