topic Re: Store PROC results and display them in a custom table in SAS Procedures

Store PROC results and display them in a custom table

Jazzman — Thu, 27 Oct 2016 09:01:37 GMT

Hello, I think the title says it all: I would like to store single results from PROC steps (i. e. regression coefficients, p-values ...) and display them later altogether in one table. It would also work for me just to print them as a list with annotations. The important thing here is that I need to display a large amount of results in an overseeable way.

I'm especially thinking of the way you can work with stored results in Stata. Every program you execute generates a number of local macros that contain the single numbers and strings that you can see in the program's output. Afterwards you can store them with custom names and after you finished all your analyses you can easily get an overview over the key outputs.

Re: Store PROC results and display them in a custom table

Reeza — Thu, 27 Oct 2016 09:10:34 GMT

ODS OUTPUT

http://blogs.sas.com/content/iml/2015/09/08/ods-table-names.html

Re: Store PROC results and display them in a custom table

RW9 — Thu, 27 Oct 2016 09:15:38 GMT

If you put:
ods trace on;

Before each step, and turn it off afterwards, you will see the ODS system generates a hidden table for each set of results it generates. These can be extracted in a few ways, out= and set a dataset in some instances, in proc means for instance you can get it from:

output out=...;

But in all case you can use:

ods output <object_name>=<dataset_name>;

To store these somewhere.