Exporting Proc Tabulate Results

[Ranjeeta]

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 · Accepted solution]

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]

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

[PaigeMiller]

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

[Kurt_Bremser]

Fixed.

---

@PaigeMiller wrote:

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

---