Hello
Can someone please advise how to export proc tabulate results properly to excel ?
I have some blank rows in the descriptor variables of he output?
Is there an easy way to get the results out neatly in excel?
The "easy" answer is ODS EXCEL. But since you haven't really been specific, its hard to say more.
ods excel file="mydrive\myfolder\excelfilename.xlsx";
proc tabulate;
...
run;
ods excel close;
The "easy" answer is ODS EXCEL. But since you haven't really been specific, its hard to say more.
ods excel file="mydrive\myfolder\excelfilename.xlsx";
proc tabulate;
...
run;
ods excel close;
Can someone advise how to neatly export proc tabulate results to excel
Duplicate thread, reply at https://communities.sas.com/t5/SAS-Programming/Exporting-Proc-Tabulate-Results/m-p/535968#M147228
Fixed.
@PaigeMiller wrote:
Duplicate thread, reply at https://communities.sas.com/t5/SAS-Programming/Exporting-Proc-Tabulate-Results/m-p/535968#M147228
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.