10-22-2015 08:43 AM
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?
10-22-2015 06:53 PM
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.
10-22-2015 08:22 PM
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.
10-22-2015 08:46 PM
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 8) 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.
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.
Need further help from the community? Please ask a new question.