BookmarkSubscribeRSS Feed

Create parameter enabling export cross table with the same design of the original SAS Visual Analytics to Excel.

Often users need to edit the data in Excel, while preserving the same design from the SAS.

 

Thanks.

4 Comments
bpazzaglini
Fluorite | Level 6

I use the SAS add-in to workaround this problem. It works.

Anyway it's a good idea 😉

ricardo_roberto
Fluorite | Level 6

I also need this resource a lot in my work. For list and cross tables.

It's a good idea.

AnnaBrown
Community Manager
Status changed to: Under Consideration

Thanks for your idea. Maintaining the structure of the data (categories on both rows and columns) is on the road map.

RickStyll_SAS
SAS Employee
Status changed to: Suggestion Implemented

The SAS product team received many requests to maintain both the orientation of the data and the style when exporting crosstabs to Excel workbooks. I'm excited to share that this idea has been implemented. It's available with SAS Visual Analytics 2020.1 (December 2020). When you choose Excel workbook from the Export right-mouse context menu on a crosstab in either view or design mode, you'll get the results in Excel where the layout/orientation of the data items is maintained. Likewise, your drill state and formatting is preserved, and you'll see the filter context displayed just above the formatted crosstab in Excel.

 

Here's a quick example.

Export to Excel Workbook VA 2020.1.1.gif