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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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