DATA Step, Macro, Functions and more

Assigning constant values from observations

Reply
N/A
Posts: 0

Assigning constant values from observations

Hi,
I have a data set containing coefficients for a regression equation (single observation with variables representing each coefficient). I would like to use the coefficients to generate predicted values in another data set of N observations. Would I be able to assign the coefficients as "constant" variables for use in the N observation data set?

Coefficients Data Set: Var1 ... Var9
N Observations Data Set: VarA ... VarX
VarA ... VarX
VarA ... VarX
Predicted = Var1 + Var2*VarA + Var9*VarX
Trusted Advisor
Posts: 2,116

Re: Assigning constant values from observations

Posted in reply to deleted_user
Think about this. As the SET statement is executable, you could read the coefficients, retain them for th DATA step, and then drop the variables from the output dataset; this is done once. You could have a second SET statement to read in the nObs dataset.

* untested code;
DATA scored;
IF _N_=1 then SET Coefficients;
RETAIN Var1-Var9;
DROP Var1-Var9;
SET NObs;
Predicted = Var1 + Var2*VarA + Var9*VarX ;
RUN;
Ask a Question
Discussion stats
  • 1 reply
  • 135 views
  • 0 likes
  • 2 in conversation