topic Moving tables from Results window to other location__part 2 in SAS Programming

Moving tables from Results window to other location__part 2

wlierman — Fri, 27 Aug 2021 16:17:38 GMT

I recently asked how to move tables or date from the Results window to another destination. I got a solution from Reeza which involved using ODS as a wrapper

ods excel file='/.....' style=meadow;
proc freq data=sashelp.class;
run;
ods excel close;

This question is just follow-up to this solution. The question is how do I

pipe tables from Results window to data sets where they can be manipulated, combined, exported or saved for further analysis or use.

Thanks for this assistance.

wklierman

Re: Moving tables from Results window to other location__part 2

maguiremq — Fri, 27 Aug 2021 16:29:59 GMT

Use the OUT = option on PROC FREQ:

proc freq
	data = sashelp.class;
		tables sex / out = s_freq;
run;

Re: Moving tables from Results window to other location__part 2

ballardw — Fri, 27 Aug 2021 17:14:27 GMT

For procedures that do not have an out= data set option, or do not allow what you want in the data set you move into the ODS OUTPUT statement. Which specifies the specific table name created by the procedure and you assign a target data set name.

Generic looks like

ods output generatedtable = mydatasetname;
Proc whatever data= mydata <other proc options>;
<other proc statements>
;
run;

You can either look up the tables created in the documentation in the details tab for most procedures, which usually has the options needed to create the table.

Or run your code once with

ods trace on;
<your proc goes here>
ods trace off;

The LOG will then show the names of the tables generated. So you could then place them into one or more ODS OUTPUT statement.

The datasets generated by ODS output are often in a different structure, with additional variables, than in the older Output statements for most procs.

Note that ODS OUTPUT will also allow you to capture the plotted points in the procedures that provide statistical graphs such as created by the Plot statement in Proc Power, most of the regression procedures and such.