topic Re: Create a custom category in SAS VA using 2 different source variables? in SAS Visual Analytics

Create a custom category in SAS VA using 2 different source variables?

asdfasdfasdfads — Wed, 24 Apr 2019 15:12:50 GMT

Hello all,

I'm trying to create a custom category in SAS VA (version 7.4, hotfix 08), but my initial dataset (which comes in from a process and can't be changed before it hits VA) has the information I need in two different places.

For example:

My data set contains 2 variables:

Variable 1: Values: A, B

Variable 2: Values: C, D, E, F

I'd like to create a custom category, Variable 3, which takes on these three following values:

X - when the value from variable 1 is A

Y - when the value from variable 1 is B AND variable 2 is C

Z - when the value from variable 1 is B AND value of variable 2 is NOT C

Is this possible somehow?

If I had to use a hierarchy of some sort, could that do the trick?

Thank you!

Re: Create a custom category in SAS VA using 2 different source variables?

Sam_SAS — Wed, 24 Apr 2019 18:48:34 GMT

Hello,

This should be possible as a calculated item rather than a custom category.

You would use nested IF/ELSE statements. Something like this:

IF ( 'Origin'n In ('Asia') )
RETURN 'X'
ELSE ( 
  IF ( ( 'Origin'n = 'Europe' ) AND ( 'Type'n NotIn ('Hybrid') ) )
  RETURN 'Y'
  ELSE 'Z' )

Re: Create a custom category in SAS VA using 2 different source variables?

asdfasdfasdfads — Wed, 24 Apr 2019 20:29:04 GMT

Thank you! I’ll give this a try.

Re: Create a custom category in SAS VA using 2 different source variables?

asdfasdfasdfads — Mon, 29 Apr 2019 12:37:42 GMT

This was successful. Thanks again for the help!