Dear everyone,
I am trying to save 2 temporary tables from PROC GLM. I would like to save the Parameter Estimates Table and also another table with columns pertaining to fitted values, standard errors, confidence limits, residuals etc. I have the following code, but I am not getting any of these 2 tables in the work folder. I also checked the log window, but there is no error message. Can someone please help me? Thank you!
data mydat;
input group $ days yy;
datalines;
A 0 7.4
A 2 7.2
A 4 7.4
A 6 6.9
A 8 6.8
A 10 6.9
A 12 6.7
A 14 6.4
A 16 6.3
B 0 8.1
B 2 8
B 4 7.9
B 6 7.8
B 8 7.7
B 10 7.9
B 12 7.5
B 14 7.4
B 16 7.2
;
run;
ods table param=ParameterEstimates;
proc glm data=mydat ;
class group;
model yy= group days days*group/noint alpha=0.05 ss1;
output out=mytable p=fitted stdr=stderr lclm=CIlower uclm=CIupper lcl=PIlower UCL=PIupper rstudent=rstudent residual=resid;
run;
ods output parameterestimates=params;
Your code is backwards, it's ODS table name and then what you'd like to call it:
ods table ParameterEstimates=param;
Thanks a lot Reeza!
@Reeza wrote:
Your code is backwards, it's ODS table name and then what you'd like to call it:
ods table ParameterEstimates=param;
Shouldn't that say ods output and not ods table?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.