I wish to estimate expenditure on a sub-sample, and use the estimates to predict expenditure for the entire sample. So in the first stage, I regress:
proc reg data=InputData outest=estimates;
model Exp = lnY lnY_2 &ivset ;
where Exp ge 100;
output out=Pred_Exp p=predexp;
run;
The problem is I then have to manually use the parameter estimates to predict expenditure for the cases with Exp<100. Is there a shorter way to do this than manually using the parameter estimates that I have saved to the dataset estimates?
In the input dataset, create a variable (call it Exp1).
data inputdata;
set inputdata;
if exp >= 100 then exp1=exp;
else exp1=.;
run;
then run proc reg as follows:
proc reg data=InputData outest=estimates;
model Exp1 = lnY lnY_2 &ivset ;
output out=Pred_Exp p=predexp;
run;
The estimates dataset will have predicted values for all of the data. This use of missing for the dependent variable is a good trick to know.
Steve Denham
In the input dataset, create a variable (call it Exp1).
data inputdata;
set inputdata;
if exp >= 100 then exp1=exp;
else exp1=.;
run;
then run proc reg as follows:
proc reg data=InputData outest=estimates;
model Exp1 = lnY lnY_2 &ivset ;
output out=Pred_Exp p=predexp;
run;
The estimates dataset will have predicted values for all of the data. This use of missing for the dependent variable is a good trick to know.
Steve Denham
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.