Send summarized formatted data to Excel

[DavidPhillips2]

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.

[Madelyn_SAS · Accepted solution]

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.

[DavidPhillips2]

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