Is there a way to output type III pvalues and bonf adjusted p values from PROC GLM into dataset?

[Hello_there]

Hi,

I'm trying to program a table that includes type 3 p values and bonferroni adjusted p values from PROC GLM? Is there a way to do that?

Thanks

[ballardw · Accepted solution]

Any of the output tables can be sent to a data set with the ODS OUTPUT statement. You need to know the name of the table created by the procedure and use

ods output tablename=nameofdesireddataset.

You can find the names of the tables generated by the procedure in the details tab of the online documentation such as here:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_glm_details70.htm

or run your procedure code with the option ODS Trace on such as

ods trace on;

proc glm data=yourdata;
  <glm statements>
run;

ods trace off;

The LOG will show the names of all the tables generated so you can use them in the Ods output.

[PaigeMiller]

You can output the Type III p-values to a SAS data set, using ODS OUTPUT, and then program additional calculations as you see fit.

The command you should insert in PROC GLM is

   ods output modelanova=modelanova;

[Ksharp]

Search "bonferroni" in this URL, you could find something.

https://support.sas.com/kb/30/333.html