topic Re: Moving tables from the Results window to a useful medium in SAS Programming

Moving tables from the Results window to a useful medium

wlierman — Wed, 25 Aug 2021 22:35:46 GMT

I have a general question regarding tables that appear in the Results window.

Can these be moved to another medium where they can be used and resized or re-positioned.

I have some frequency tables of race_ethnicity that I want to send to another person (not sure if they have SAS or not). I right-clicked in the Results window and there was an option to export to excel.

When I tried that my session 'froze' there was no response to to back out of the window or get back to the program code. I had IT kill the session.

Are there any straightforward ways to use the output from the Results pane?

Thank you.

wklierman

Re: Moving tables from the Results window to a useful medium

Reeza — Wed, 25 Aug 2021 22:42:00 GMT

I usually pipe the results directly to my destination of choice instead, results window/copy/paste is the 'old' way 😉

Add an ODS wrapper around the start and end of code you'd like to display in the output. You can use ODS SELECT/EXCLUDE if you want to include/exclude certain tables/outputs. I'm assuming you're aware of how to pipe these tables to data sets as well, that could also be manipulated and then either exported, combined or saved for later use.

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

Re: Moving tables from the Results window to a useful medium

SASKiwi — Wed, 25 Aug 2021 23:03:12 GMT

Are you using Enterprise Guide by any chance? The method you are using is really only designed for small tables, for example a few thousand rows. @Reeza 's method is better for large tables.

Re: Moving tables from the Results window to a useful medium

wlierman — Wed, 25 Aug 2021 23:19:11 GMT

I am not familiar with the piping method. That sounds very useful being able to move the data to
a data set. How does that work?

Thanks.
wklierman

Re: Moving tables from the Results window to a useful medium

wlierman — Wed, 25 Aug 2021 23:22:11 GMT

I am using a window version of SAS. A couple of the tables are large since they have maybe 15-20 R/E designations.

Re: Moving tables from the Results window to a useful medium

Reeza — Mon, 30 Aug 2021 16:12:28 GMT

Here's some instructions and explanations on how to capture output that is shown.
https://blogs.sas.com/content/sastraining/2017/03/31/capturing-output-from-any-procedure-with-an-ods-output-statement/