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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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