Moving tables from the Results window to a useful medium

[wlierman]

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

[Reeza · Accepted solution]

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;

[wlierman]

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

[Reeza]

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...

[SASKiwi]

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.

[wlierman]

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