topic Re: compare value in same column in SAS Programming

compare value in same column

jojozheng — Fri, 16 Nov 2018 22:06:50 GMT

Hi,

I have a dataset like below:

id date type

1 SEP A

1 SEP B

1 SEP C

2 SEP B

3 SEP C

4 SEP B

4 SEP C

I want like below: group by id,date, if this id in specific time, in all the type he has, if he has type A then his new type will be A and ignore other type.

so the important type should be A>B>C.

id date type_new

1 SEP A

2 SEP B

3 SEP C

4 SEP B

how can I solve this? Thank you!

Re: compare value in same column

novinosrin — Fri, 16 Nov 2018 22:18:55 GMT

if the type is actually A,B,C etc ranked i.e sorted by hierarchy as your sample is

all you need is

data want;

set have;

by id date type;

if first.id;

run;

Re: compare value in same column

jojozheng — Fri, 16 Nov 2018 22:24:19 GMT

if it is not in that order, it shuffles like
1 sep b
1 sep c
1 sep a

what should I do?

Re: compare value in same column

novinosrin — Fri, 16 Nov 2018 22:26:08 GMT

I would keep a look up table like, and it;s easy to update look up table when needed

Type rank

a 1

b 2

c 3

and look up using join, merge, hash,format etc

Re: compare value in same column

jojozheng — Fri, 16 Nov 2018 22:29:37 GMT

thank you!