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;
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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.