Hello,
I ran the following multiple linear regression:
proc reg data=regress1 outest=regress2;
model PERF = MKT SMB HML;
by id;
run;
and I would like to export the R² from all the regressions (for each ID) in an excel file.
However, even with 'outest', I only obtain RMSE and intercept for each ID.
Thanks a lot in advance for your help.
Max
ods output fitstatistics = fitstatistics;
proc reg ...
Will create a data set named fitstatistics which contains the R-squared values.
Alternatively, if you don't want to parse the ods file, just use the EDF option. e.g.:
proc reg data=class edf outest=regress3; model age = height weight; by sex; run;
Art, CEO, AnalystFinder.com
But then you have to parse the OUTEST file.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.