Simplify multiple if/then condition

Dunne — Wed, 28 Nov 2018 23:17:45 GMT

Hello,

Could anyone help me with? I want if any dx1-dx4 <=9 the generate a variate dx with the smallest dx (ex id=4 the smallest dx <-9 is of dx2). If all dx1-dx4 >9 then take the value of the smallest dx but not the value of 999.

Id	dx1	dx2	dx3	dx4
1	1	2	10	999
2	10	11	8	13
3	999	10
4	13	1	4	5
5	9	1	2	13

and I want the result looks like this

id	dx
1	1
2	8
3	10
4	1
5	9

Thank you,

Re: Simplify multiple if/then condition

Astounding — Wed, 28 Nov 2018 23:32:26 GMT

Why should ID 5 generate 9, and not 1?

Except for that, a short program would do:

data want;

set have;

dx = min(of dx1-dx4);

if dx=999 then dx=.;

run;

topic Re: Simplify multiple if/then condition in New SAS User

Simplify multiple if/then condition

Re: Simplify multiple if/then condition