topic Re: Proc Tabulate Report(IN SAME FORMAT) to server and then to local drive in SAS Programming

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

sasuser_sk — Tue, 17 Nov 2020 20:38:03 GMT

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!

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

ChrisNZ — Tue, 17 Nov 2020 23:14:13 GMT

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

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

sasuser_sk — Wed, 18 Nov 2020 17:44:01 GMT

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.