Help using Base SAS procedures

Store PROC results and display them in a custom table

Reply
Occasional Contributor
Posts: 12

Store PROC results and display them in a custom table

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.

Super User
Posts: 17,750

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

Super User
Super User
Posts: 7,392

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 183 views
  • 0 likes
  • 3 in conversation