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

Visual Analyltics-- Can crosstab row that is the measure?

Reply
New Contributor
Posts: 3

Visual Analyltics-- Can crosstab row that is the measure?

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

PROC Star
Posts: 7,357

Re: Visual Analyltics-- Can crosstab row that is the measure?

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
 
New Contributor
Posts: 3

Re: Visual Analyltics-- Can crosstab row that is the measure?

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

SAS Super FREQ
Posts: 435

Re: Visual Analyltics-- Can crosstab row that is the measure?

Crosstabs support measures only on the columns.

New Contributor
Posts: 3

Re: Visual Analyltics-- Can crosstab row that is the measure?

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.

Ask a Question
Discussion stats
  • 4 replies
  • 137 views
  • 0 likes
  • 3 in conversation