Solved
Contributor
Posts: 71

# Recode using if statement

[ Edited ]

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

Accepted Solutions
Solution
‎08-02-2016 02:58 PM
Super User
Posts: 19,862

## Re: Recode using if statement

x=CATT(of var1-var6);

All Replies
Super User
Posts: 19,862

## Re: Recode using if statement

Is your second last record correct or should it be ARR?

Contributor
Posts: 71

## Re: Recode using if statement

[ Edited ]

Yes it should be ARR.

Thank you.

Super User
Posts: 19,862

## Re: Recode using if statement

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.

Contributor
Posts: 71

## Re: Recode using if statement

Sorry, my bad, yes it should be ARR.

Super User
Posts: 19,862

## Re: Recode using if statement

You should post samples that include what happen in other conditions, ie what if they're not blank.

Contributor
Posts: 71

## Re: Recode using if statement

Thank you - it should  be "unknown" if none of the conditions meet.

Thanks

Solution
‎08-02-2016 02:58 PM
Super User
Posts: 19,862

## Re: Recode using if statement

x=CATT(of var1-var6);

Contributor
Posts: 71

## Re: Recode using if statement

Thank you so much.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
• 8 replies
• 524 views
• 1 like
• 2 in conversation