BookmarkSubscribeRSS Feed
chris_birrell
Calcite | Level 5

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

 

2 REPLIES 2
DavidPope
SAS Employee

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.

TriciaAanderud
Lapis Lazuli | Level 10

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.


Tricia Aanderud

Twitter: @taanderud - Follow me!

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 2 replies
  • 1293 views
  • 0 likes
  • 3 in conversation