Thanks @PGStats
I'm almost there, but two issues remain:
Most importantly, I want to determine if there is a significant change in R2 from one model to the next--my fault for not specifying this earlier--I'll update the initial post momentarily. As such, I need not only the change in R2 from one model to the next, but an F statistic and p-value to determine whether the change after adding variables is significant.
The output is presently in the log and not labeled. Is there a way to get formatted output?
Of note, here is the actual syntax I'm using, please build from it if possible. I'm adding to sets of variables to the initial equation. So there are 3 models and two comparisons for change in R-square:
proc reg data=pt8 edf outest=r2 plots=none;
Covariates: model jobSat= I IM A AM;
Linear: model jobSat= R RM I IM A AM;
Quadratic: model jobSat= R RM RM2 R2 RInt I IM A AM;
run;
quit;
data _null_;
set r2(where=(_model_="Covariates"));
R2_Covariates = _RSQ_;
set r2(where=(_model_="Linear"));
R2_Linear = _RSQ_;
set r2(where=(_model_="Quadratic"));
R2_Quadratic = _RSQ_;
R2_diff1 = R2_Linear - R2_Covariates;
R2_diff2 = R2_Quadratic - R2_Linear;
put (R2_:) (percentn6.1);
run;
Many thanks!
... View more
