BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
titan31
Quartz | Level 8

Hi,


We've just moved to VA 7.5 and with the removal of Explorer Mode, we have some users who had reports in that complaining that when they export their crosstabs, it doesn't stay in a pivot format but just lists out the data. 

 

Is there anyway to get the crosstab to stay in the same format, or is it something that users are just going to have to live with?

 

THanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

The only option to retain the crosstab format is to open the table directly in Microsoft  Excel using the SAS Add-in for  Microsoft Office, assuming the users have that available.. 

View solution in original post

4 REPLIES 4
Madelyn_SAS
SAS Super FREQ

The only option to retain the crosstab format is to open the table directly in Microsoft  Excel using the SAS Add-in for  Microsoft Office, assuming the users have that available.. 

RickStyll_SAS
SAS Employee

SAS Visual Analytics 2020.1 (December 2020) on Viya 4 added the ability to maintain the format of your crosstab when exporting to an Excel workbook. When you choose Excel workbook from the Export right-mouse context menu on a crosstab in either view or design mode, you'll get the results in Excel where the layout/orientation of the data items is maintained. Your drill or expand state and formatting are preserved too, and you'll see the filter context displayed just above the formatted crosstab in Excel.

 

Export to Excel Workbook VA 2020.1.1.gif

cdw90nl
Calcite | Level 5

@RickStyll_SAS we have SAS VA 7.5(OS: windows) and we are considering an upgrade to sas viya(Windows). Is this also available for the windows platform already? 

Joy_SAS
SAS Employee

Hi @cdw90nl

 

Yes, the feature of exporting from SAS Visual Analytics to an Excel workbook has been available starting in the 2020.1.1 stable release (in December 2020) for SAS Viya. If you prefer a long-term support release for SAS Viya, the feature is available in 2021.1 (May 2021). Here's the What's New documentation for 2021.1: here: https://documentation.sas.com/doc/en/vacdc/v_008/vawn/p0inasrahy7vwkn1269nd92dp1r6.htm

 

-Joy

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1790 views
  • 3 likes
  • 5 in conversation