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

[wlierman]

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

[PaigeMiller · Accepted solution]

Not a copy and paste at all.

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

or ODS EXCEL

[wlierman]

Thank you.  The pdf is created.
wlierman

[PaigeMiller]

@wlierman 

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

[wlierman]

Will do.