BookmarkSubscribeRSS Feed
Obsidian | Level 7

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,

Super User

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;



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3 in conversation