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,113

Re: Assigning constant values from observations

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