07-29-2016 01:40 PM - edited 07-29-2016 02:29 PM
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;
Basically I need help with how to tell if statement to make sure that the combination is correct provided all other variables are null.
Need further help from the community? Please ask a new question.