topic measure data as a hierarchy in SAS Visual Analytics in SAS Visual Analytics

measure data as a hierarchy in SAS Visual Analytics

chris_birrell — Thu, 05 May 2016 12:48:01 GMT

Hi,

I'm fairly new to SAS VA and am trying to work with 'measure' data as a hierarchy. I work with income data for instance and I need to be able to produce reports that have the roll-up of variables embedded. Here's an example of a hierarchy that I would use:

Market income

-Wages and salaries

-Self-employment earnings

- farm

- non-farm

-Pensions

-Investments

- dividends

- interest

- etc.

-Other

All of this data $ amounts and I want to be able to produce a report where I can click the high level variable and get a picture of what's happening. Another click and I see the next level in the hierarchy.

Problem I'm having is that the hierarchy is limited to categorical variables in SAS VA. There must be a work around, but it's not clear to me. Any help is much appreciated! The reports just need to produce basic summary stats. Sum, counts, average min ,max, median etc.

Thanks,

Chris

Re: measure data as a hierarchy in SAS Visual Analytics

DavidPope — Thu, 05 May 2016 15:33:48 GMT

You can force a variable to become a category by changing its property, however, I don't think this will solve your issue because then the measure will no longer be available. So you may consider creating new variables based on the measures and forcing them to be category.

Re: measure data as a hierarchy in SAS Visual Analytics

TriciaAanderud — Sat, 07 May 2016 10:28:09 GMT

I suspect your data needs to be transposed. So instead of looking like this:

Wages Farm Non-Farm

123 100 23

It needs to be shaped like this:

Income Source SubSource Wages

Market Self-Employee Farm 100

Market Self-Employee Non-Farm 23

Then you can build the hierarchy from Income, Source, SubSource and Wages is your measure.