topic Column labels not exporting to Excel in SAS Visual Analytics

Column labels not exporting to Excel

dstephens22 — Thu, 22 Oct 2015 12:43:06 GMT

Hi:

I have a crosstab that uses date as columns. When exporting this transposes the data and the dates appear as rows.

Does anybody have a workaround for this?

Thanks,

Dave

Re: Column labels not exporting to Excel

kannand — Thu, 22 Oct 2015 22:53:04 GMT

Would it be possible to provide an example? I am not familiar with the term crosstab in Excel. Any additional info example you can share might help.

Re: Column labels not exporting to Excel

dstephens22 — Fri, 23 Oct 2015 00:22:08 GMT

Thanks for the inquiry. I guess I didn't explain properly. I attached two screen shots in VA. First is the dashboard view.

The second is what it's exporting. I was curious if I could keep the same format from the dashboard.

thanks,

dave

Re: Column labels not exporting to Excel

dstephens22 — Fri, 23 Oct 2015 00:22:36 GMT

Re: Column labels not exporting to Excel

kannand — Fri, 23 Oct 2015 00:46:20 GMT

Thanks Dave.

I looked at both the screenshots and I realize that one is a dashboard and the other is the data behind the dashboard. I am not familiar with SAS VA product. However, I was able to notice this SESUG 2015 paper mentioned (under title "Fringe Benefits on page 😎 that the detailed data from SAS VA can be exported to Excel by a click of a button. It says "the detailed data ". In this case the dashboard is a presentation of the detailed data as I understand, which is stored in a different format. So, when you try to export the dashboard, I guess it exports the detailed data behind the dashboard.

http://www.lexjansen.com/sesug/2015/125_Final_PDF.pdf

Logically thinking, if you need the exact view on xls, I would guess selecting all (Ctrl+A), copying (Ctrl+C) from the dashboard and then within Excel, if you paste (Ctrl+V), I would guess that it might work in getting the same headers and column row headers and column headers copied on to Excel application. However, if you are trying to automate this in a production environment, I am not sure of an automated solution. Hope this atleast steers you in the right direction.

Good luck Dave.

Re: Column labels not exporting to Excel

Madelyn_SAS — Tue, 27 Oct 2015 15:03:55 GMT

SAS Note 55909 explains the behavior you are seeing. As a workaround, you can open the report directly in Excel using the SAS Add-In for Microsoft office.