Exporting the Cross tab as is

[sandeep_18]

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.

[Sam_SAS]

Hello Sandeep,

Is the top image the exported output?

Which version of VA do you have?

Thanks,
Sam

[sandeep_18]

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.

[Madelyn_SAS]

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.

[Sam_SAS]

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

[sandeep_18]

Thank u Sam.