I want to create a new variable called new var
conditions for recoding are:
if var1 = 'A' and all other var2 - var5 are blank then newvar = A;
if var1 = 'A' and any of the var2-var5 are B and nothing else in the vars (should be blank) then newvar = AB
if var1='A' and var2= 'R' then newvar but all other vars should be null or blank = AR;
VAR1 | VAR2 | VAR3 | VAR4 | VAR5 | VAR6 | Newvar |
A | A | |||||
A | B | AB | ||||
A | B | AB | ||||
A | B | AB | ||||
A | B | AB | ||||
A | R | AR | ||||
A | B | R | ABR | |||
A | R | R | ARR | |||
A | R | AR |
Basically I need help with how to tell if statement to make sure that the combination is correct provided all other variables are null.
Thanks
Is your second last record correct or should it be ARR?
Yes it should be ARR.
Thank you.
@AZIQ1 wrote:
Yes.
That's an or question not a yes/no question. Please take the time to detail your question and answers otherwise why should we take the time to answer them.
Sorry, my bad, yes it should be ARR.
You should post samples that include what happen in other conditions, ie what if they're not blank.
Thank you - it should be "unknown" if none of the conditions meet.
Thanks
What about
x=CATT(of var1-var6);
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.