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);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.