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?
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 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.