topic Re: output tables from proc glm in ODS and Base Reporting

output tables from proc glm

statz — Mon, 14 Dec 2015 14:34:37 GMT

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;

Re: output tables from proc glm

PaigeMiller — Mon, 14 Dec 2015 14:51:40 GMT

ods output parameterestimates=params;

Re: output tables from proc glm

Reeza — Mon, 14 Dec 2015 15:27:39 GMT

Your code is backwards, it's ODS table name and then what you'd like to call it:

ods table ParameterEstimates=param;

Re: output tables from proc glm

statz — Mon, 14 Dec 2015 15:32:25 GMT

Thanks a lot Reeza!

Re: output tables from proc glm

PaigeMiller — Mon, 14 Dec 2015 15:40:29 GMT

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