Creating a new variable based on the value of multiple other variables

CydneyLB — Fri, 12 Apr 2019 11:02:03 GMT

Hi,

I currently have data that looks like this:

ID Field_1 Field_2 Field_3 Field_4 Field_5

1 3 1 . . .

2 1 2 1 . .

3 1 1 . . .

4 2 3 2 . .

5 2 . . . .

6 1 1 1 3 3

ect

I need to create a new variable (Total_Field) based on the values in Fields 1- 5 as follows:

If any Field is 3 then Total_Field = 3

if an id has both a Field = 1 & a Field = 2 then Total_Field = 3

if an id has only Field's= 1 then Total_Field = 1

if an id has only Field's = 2 then Total_Field = 2.

So for the above data Total_Field would be:

ID Total_Field

1 3

2 3

3 1

4 3

5 2

6 3

I know i could do this with if then statements but it would be really long winded so I'm hoping there is a quicker way?

Thanks

Cydney

Re: Creating a new variable based on the value of multiple other variables

gamotte — Fri, 12 Apr 2019 11:54:25 GMT

Hello,

Something like this ?

array f field:;

total_field=ifn(3 in f or (1 in f and 2 in f),3, field1);

CydneyLB — Fri, 12 Apr 2019 13:30:09 GMT

This worked perfectly!

Thank you very much 🙂