topic Exporting Proc Tabulate Results in SAS Programming

Exporting Proc Tabulate Results

Ranjeeta — Fri, 15 Feb 2019 19:11:17 GMT

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?

PaigeMiller — Fri, 15 Feb 2019 19:15:23 GMT

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;

Ranjeeta — Fri, 15 Feb 2019 19:20:33 GMT

Can someone advise how to neatly export proc tabulate results to excel

PaigeMiller — Fri, 15 Feb 2019 19:23:39 GMT

Kurt_Bremser — Fri, 15 Feb 2019 19:49:20 GMT

Fixed.

@PaigeMiller wrote:

Duplicate thread, reply at https://communities.sas.com/t5/SAS-Programming/Exporting-Proc-Tabulate-Results/m-p/535968#M147228