BookmarkSubscribeRSS Feed
gordon13267
Fluorite | Level 6

Hello,

 

Hi I'm new to Visual Analytics, and like the product, but have come across an issue when displaying information, Hopefully it's due to my lack of knowledge, but I can't seem to find a way to display measures or values in rows instead of columns. I have too many measures and would like to put them in rows. 

Can someone show me how to do it?

 

 

Thank you!

 

Rita

4 REPLIES 4
art297
Opal | Level 21

I've never used Visual Analytics but, according to the documentation:

 

Rearrange Rows and Columns

To rearrange your rows and columns, drag and drop the row headings and column headings.
 
Is that what you are trying to do?
 
Art, CEO, AnalystFinder.com
 
gordon13267
Fluorite | Level 6

Thanks, but that is not what I meant to do. 

Madelyn_SAS
SAS Super FREQ

Crosstabs support measures only on the columns.

gordon13267
Fluorite | Level 6

Yes, that's true.

After I did several experiments, I figured out the way to solve this problem is to restructure the raw data. 

I transposed the variables into rows from columns in my raw data file. 

It works on VA for this specific purpose.

Thanks for all your help.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 1873 views
  • 0 likes
  • 3 in conversation