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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.