I have a firm-date panel and wanted to generate predict value (beta hat) for s_score at the date level. So far, I have the below and wanted to ask you if you knew how to do this.
proc sort data=b5; by date; run;
proc reg data=b5; by date; model mtb = size roa s_score/adjrsq;
output out=o1 p=p residual=r; run; quit;
when i do this, i get a p value next to every single firm date obs.
essentially, i want a b to s_score at the date level.
Thank you in advance,
You should also have parameter estimate for each date as well in the Parameter estimates.
Do you mean that you want the parameter in an output data set? That would be from using the OUTEST= option on the Proc Reg statement.
To expand on @ballardw's reply, the statistics that you are looking for are called "parameter estimates." That should help you with internet searches.
In addition to using the OUTEST= option, you should add the NOPRINT option to the PROC REG statement so that the screen is not filled with hundreds of tables/graphs that you don't need to see. The following statements create an output data set called ParamEst that contains all parameter estimates. You can use a WHERE clause to restrict the output it you only want the estimates for s_score.
proc reg data=b5 outest=ParamEst noprint;
by date;
model mtb = size roa s_score / adjrsq;
quit;
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.