topic Re: Copying proc freq tables from Results pane to pdf or excel format in SAS Programming

Copying proc freq tables from Results pane to pdf or excel format

wlierman — Thu, 24 Oct 2024 17:07:36 GMT

My question is: How do I copy frequency tables from the Results pane to another format like pdf or excel so they can be emailed to other individuals?

proc freq data=ANALYZE4.urban_rural;
by clm_type_ohg_desc;
table flag_telehealth*desi

The tables in the Results viewer are labeled sashtml. When I right-click on the table and 'Export to Excel' appears. But I can't locate the excel worksheet.

So, in summary I need to copy frequency tables from the Result Viewer to another format (Excel would be best, however, as I mentioned I can't locate the resulting excel worksheet).

Thank you for sharing your time and expertise on this.

wlierman

Re: Copying proc freq tables from Results pane to pdf or excel format

PaigeMiller — Thu, 24 Oct 2024 17:14:43 GMT

Not a copy and paste at all.

ods pdf file='myfile.pdf';
proc freq ...
...
run;
ods pdf close;

or ODS EXCEL

Re: Copying proc freq tables from Results pane to pdf or excel format

wlierman — Thu, 24 Oct 2024 23:53:11 GMT

Thank you. The pdf is created.
wlierman

Re: Copying proc freq tables from Results pane to pdf or excel format

PaigeMiller — Fri, 25 Oct 2024 09:40:55 GMT

@wlierman

Please help all users of this community by marking my answer as correct.

Re: Copying proc freq tables from Results pane to pdf or excel format

wlierman — Fri, 25 Oct 2024 13:10:16 GMT

Will do.