SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Recode using if statement

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

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;

 

 

VAR1VAR2VAR3VAR4VAR5VAR6Newvar
A     A
AB    AB
A B   AB
A  B  AB
A   B AB
AR    AR
ABR   ABR
ARR   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

What about 

 

x=CATT(of var1-var6);

 

View solution in original post


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

What about 

 

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