topic Re: Different drill down levels in SAS Visual Analytics

Different drill down levels

Schwami — Thu, 07 Mar 2019 10:34:54 GMT

Is is possible to use different drill down levels in one crosstab?

Example:

I have a hierarchy following the structure of this example: Mammal -> Dog -> Labrador

What i want is a crosstab like this:

- Mammal

- Dog

- Labrador

Cat

As you can hopefully understand. I want to be able to drill down on dog, but not on cat for some reason. Is something like this remotely possible? I'm using SAS VA 7.4.

Re: Different drill down levels

FredrikE — Thu, 07 Mar 2019 11:59:21 GMT

Hm, i don't think you can have different length/depth/levels on the branches.

One thing you can do is to create your own categories and apply a rule in them so that the next level is the same as the one before:

- Mammal

- Dog

- Labrador

Cat

- Cat

Lets say you have the following categories:

- Level1 (mammal)

- Level2 (dog,cat)

- Level3 (labrador)

Then you would create a new level3, lets say level3_new 🙂 and do the calculation:

if level2 = cat then cat

else level3

In the cross tab you will have all levels but for cat you will get the same value for level2 and 3, might help you 🙂 ?

//Fredrik

Re: Different drill down levels

Schwami — Mon, 11 Mar 2019 08:50:43 GMT

Thanks for the help Fredrik.

This is indeed how I resolved the issue at the moment.

Re: Different drill down levels

AnnaBrown — Mon, 11 Mar 2019 13:29:47 GMT

I'm glad you found some useful info @Schwami! If Frederik's reply was the exact solution to your problem, can you "Accept it as a solution"? This will help other community members who may run into the same issue know what worked.

Thanks!
Anna