Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Column labels not exporting to Excel

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

Column labels not exporting to Excel

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

 


Accepted Solutions
Solution
‎02-19-2016 08:52 AM
SAS Super FREQ
Posts: 407

Re: Column labels not exporting to Excel

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.

View solution in original post


All Replies
Regular Contributor
Posts: 161

Re: Column labels not exporting to Excel

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.

 

 

Kannan Deivasigamani
Contributor
Posts: 24

Re: Column labels not exporting to Excel

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

 

Attachment
Contributor
Posts: 24

Re: Column labels not exporting to Excel

 
Attachment
Regular Contributor
Posts: 161

Re: Column labels not exporting to Excel

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 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.  

 

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.

 

Kannan Deivasigamani
Solution
‎02-19-2016 08:52 AM
SAS Super FREQ
Posts: 407

Re: Column labels not exporting to Excel

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.
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 421 views
  • 0 likes
  • 3 in conversation