I have developed a cross tab in report designer and saved it .I am trying to export the cross tab as is .But Its not the same cross tab that is showing her.Both are different.
Please go through the screenshots.
Hi Sam,
Thanks for your reply .We r using SAS VA Version 7.4.
The 1st image is the output.
The 2nd image is the screenshot of the report in Report designer.
Visual Analytics Designer and Viewer export crosstabs in list table format. The crosstab format is not preserved. An alternative is to use the SAS Add-In for Microsoft Office to view all or parts of the Visual Analytics report.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
As Madelyn says, the Report Designer exports a crosstab as a table.
I'm not sure if it would make sense to do so, but you could create the same crosstab in the VA Explorer and export it as a crosstab. The Explorer handles exporting crosstabs differently.
Sam
Thank u Sam.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.