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

[asdfasdfasdfads]

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!

[Sam_SAS · Accepted solution]

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' )

[asdfasdfasdfads]

This was successful.  Thanks again for the help!

[asdfasdfasdfads]

Thank you! I’ll give this a try.