Proc Tabulate Report(IN SAME FORMAT) to server and then to local drive

[sasuser_sk]

Hello All - I have built a program code to export SAS data to server and then off to local drive. I have 1 excel workbook(called results) with 2 spreadsheets in it.

Then I ran proc tabulate(pivot table-below) and now I want to add the output/sas report(in pic below) from tabulate in the same format to the RESULTS workbook(export to server in the pic below is generating that excel workbook on server).

Can someone help please!

[ChrisNZ]

You probably should put the proc tabulate in a ods excel block rather than run it beforehand.

[sasuser_sk]

Thanks for your reply. I tried ODS Excel and that exports data but not the same format of the output from proc tabulate. Although ODS PDF does the work but I'm wanting to see if exporting the same format to excel is doable in one way or another.