topic Re: Recode using if statement in SAS Data Management

Recode using if statement

AZIQ1 — Fri, 29 Jul 2016 18:29:14 GMT

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

Re: Recode using if statement

Reeza — Fri, 29 Jul 2016 18:26:23 GMT

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

Re: Recode using if statement

Reeza — Fri, 29 Jul 2016 18:30:42 GMT

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

Re: Recode using if statement

AZIQ1 — Fri, 29 Jul 2016 18:48:08 GMT

Yes it should be ARR.

Thank you.

Re: Recode using if statement

Reeza — Fri, 29 Jul 2016 18:34:58 GMT

@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.

Re: Recode using if statement

AZIQ1 — Fri, 29 Jul 2016 18:48:36 GMT

Sorry, my bad, yes it should be ARR.

Re: Recode using if statement

AZIQ1 — Fri, 29 Jul 2016 18:49:45 GMT

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

Thanks

Re: Recode using if statement

Reeza — Fri, 29 Jul 2016 19:25:15 GMT

What about

x=CATT(of var1-var6);

Re: Recode using if statement

AZIQ1 — Tue, 02 Aug 2016 18:59:33 GMT

Thank you so much.