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!
... View more