topic Re: Category and measure in Visual Analytics in SAS Visual Analytics

Category and measure in Visual Analytics

sas_it — Wed, 13 Oct 2021 04:23:56 GMT

I am having the variables with value 0 an 1. So in measure it shows count. But when i convert that to category as i want to create hierarchy does the count differs as it has 0 and 1 as values.

Re: Category and measure in Visual Analytics

acordes — Wed, 13 Oct 2021 11:11:51 GMT

I don't understand 100% your question.

BUT perhaps this may be your solution:

Depending on the context the "convert to category" option still treats the "categorical" variable as numeric preventing you from using it in a hierarchy for example.

You can overcome this by creating a categorical expression of your numerical variable by creating a calculated item "_ch_numvar" in this manner:

format(numeric_variable, best12.)

then it behaves like truly categorical

Re: Category and measure in Visual Analytics

sas_it — Wed, 13 Oct 2021 11:16:26 GMT

Thank you for your suggestion but in hierarchy only category items are accepted. Can I merge two or more categories ?

Re: Category and measure in Visual Analytics

acordes — Wed, 13 Oct 2021 11:18:43 GMT

the newly created item _ch_numvar is categorical.

This is achieved by using the format operator on a numerical variable. give it a try

Re: Category and measure in Visual Analytics

sas_it — Wed, 13 Oct 2021 11:41:04 GMT

As I have to create hierarchy so I tried to convert to category from numeric and created category of that variable and chose 1 and created hierarchy. Is this correct?

Re: Category and measure in Visual Analytics

acordes — Wed, 13 Oct 2021 11:44:11 GMT

No, you have to create a new data item.

call it character expression of your numerical variable.

use the FORMAT operator and place the numerical variable inside, choose best12. for the format.

this newly created data item works in hierarchies.

Re: Category and measure in Visual Analytics

sas_it — Wed, 13 Oct 2021 12:53:47 GMT

For the calculated item variable i am checking if a=1 then return 1 else 0 for count. As variable contains 0 0r1 but i require 1(count of it). Is it correct?