topic Re: How to pipe tables from the Results screen to another location in SAS Programming

How to pipe tables from the Results screen to another location

wlierman — Mon, 23 May 2022 19:30:44 GMT

I am looking for the best way to pipe tables (like from proc freq) in the Results screen into some other more usable format for additional analysis. Forms like an output SAS data set for further manipulation or an Excel worksheet.

I've looked at SAS Documentation on the SAS website but it is a bit obfuscated (at least for me).

Thank you.

wlierman

Re: How to pipe tables from the Results screen to another location

Tom — Mon, 23 May 2022 19:37:39 GMT

What procedure are you using now to produce the reports you are seeing now in your Results?

Check if the procedure can generate a dataset instead of a report. For example for PROC FREQ use the OUT= option on the TABLES statement.

proc freq data=have;
  tables var1 / noprint out=counts;
run;

If the procedure does not have native facility to produce datasets instead of a report check if you can use ODS OUTPUT to get a dataset of the information used to produce the report. Use the ODS TRACE statement to see what outputs are available for the report you are running.

Re: How to pipe tables from the Results screen to another location

wlierman — Mon, 23 May 2022 20:02:19 GMT

Thank you. I can go the dataset route.

Appreciate your suggestions.

wlierman