topic dynamic pivot tables from sas to excel version 9.3. in SAS Programming

dynamic pivot tables from sas to excel version 9.3.

Whitlea — Thu, 13 Apr 2023 14:17:42 GMT

Is there a way to created a dynamic pivot table in SAS and export it to Excel using version 9.3?
Thanks for your help!

Re: dynamic pivot tables from sas to excel version 9.3.

ballardw — Thu, 13 Apr 2023 14:20:13 GMT

Define what you mean by "Dynamic Pivot table".

I assume you mean from SAS 9.3. Sending output from SAS 9.3 would mean using ODS tagsets.excelxp which creates XML output that Excel can read.

Re: dynamic pivot tables from sas to excel version 9.3.

PaigeMiller — Thu, 13 Apr 2023 17:09:05 GMT

ODS EXCEL/PROC REPORT can create pivot tables, which can adjust as the data changes without human intervention — if today you have JAN2023 to APR2023 data, and a month from now you also have MAY2023 data, if done properly you don't have to change the code to get the newer data into the proper place in the table.