BookmarkSubscribeRSS Feed
kbwork
Calcite | Level 5

outestDoes anyone know how to write a statement like outest=estparms but that outputs all of the nonlinear OLS parameter estimates for each cluster instead of just the estimate?  So that creates a table that shows the parameter, estimate, approx STD Err, t value and approx Pr > |t| for each cluster?

I am currently using the statement below.  I am looking to find a better way to look at the parameter estimates for each cluster side by side as opposed to each on their own page like the pdf creates.

ods pdf file=' ***** ';

ods trace on;

proc model data = Opti.total_imp;

endogenous clicks;

impressions = a1*(1+a3*Mon+a4*tue +a5*Wed +a6*Thu + a7*Fri)*a8;

fit  impressions /ols outest=estparms maxiter=200;

by cluster;

run;

quit;

ods trace off;

ods pdf close;

1 REPLY 1
Reeza
Super User

I think you'll have to capture the table and then transpose it.

Have you looked at the ODS table?

ODS TABLE PARAMETERESTIMATES=want;

proc model data = Opti.total_imp;

endogenous clicks;

impressions = a1*(1+a3*Mon+a4*tue +a5*Wed +a6*Thu + a7*Fri)*a8;

fit  impressions /ols outest=estparms maxiter=200;

by cluster;

run;

quit;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1250 views
  • 0 likes
  • 2 in conversation