topic Re: Exporting the Cross tab as is in SAS Visual Analytics

Exporting the Cross tab as is

sandeep_18 — Tue, 26 Feb 2019 08:32:12 GMT

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.

Re: Exporting the Cross tab as is

Sam_SAS — Tue, 26 Feb 2019 14:15:05 GMT

Hello Sandeep,

Is the top image the exported output?

Which version of VA do you have?

Thanks,
Sam

Re: Exporting the Cross tab as is

Madelyn_SAS — Tue, 26 Feb 2019 14:29:42 GMT

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.

Re: Exporting the Cross tab as is

sandeep_18 — Wed, 27 Feb 2019 05:55:49 GMT

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.

Re: Exporting the Cross tab as is

Sam_SAS — Wed, 27 Feb 2019 13:46:47 GMT

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

Re: Exporting the Cross tab as is

sandeep_18 — Tue, 05 Mar 2019 10:51:43 GMT

Thank u Sam.