topic Re: Visual Analyltics-- Can crosstab row that is the measure? in SAS Visual Analytics

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

gordon13267 — Thu, 27 Apr 2017 18:15:25 GMT

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

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

art297 — Thu, 27 Apr 2017 20:17:31 GMT

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

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

Madelyn_SAS — Thu, 27 Apr 2017 20:31:21 GMT

Crosstabs support measures only on the columns.

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

gordon13267 — Wed, 03 May 2017 19:42:08 GMT

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

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

gordon13267 — Wed, 03 May 2017 19:47:36 GMT

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.