topic Send summarized formatted data to Excel in SAS Visual Analytics

Send summarized formatted data to Excel

DavidPhillips2 — Fri, 12 Nov 2021 16:00:46 GMT

Is there a way to send summarized formatted data to Excel in Visual Analytics similarly to how you can in Web Report Studio? There appears to have been a loss of functionality with this feature. In Web Report studio when you select a series of tabular fields you can send it to Excel Exactly as you see it on the screen. In VA when you do this categories that repeat, repeat in the output and the data is displayed in record format rather than report format.

E.g.

If one college has three Majors college is displayed once and each major is displayed.

Re: Is

Madelyn_SAS — Fri, 12 Nov 2021 16:00:23 GMT

I believe you are referring to preserving the crosstab structure of the table. That was added starting in the 2020.1.1 release. In that release, SAS Visual Analytics can preserve the crosstab or the list table structure when you export data to an Excel workbook.

Re: Is

DavidPhillips2 — Fri, 12 Nov 2021 16:05:03 GMT

Madelyn, Thanks, I'll check with our SAS Administrator to see if we can install that patch.