Data Step

[Tal]

Hi guys,

I have  a dataset like this below:

id      type   Score
100   A        12

100   A         11

101   B         10

101   A          9

101   C          12

102   B          13

102   B           5

102   B          7

103   A           4

103   C            6

........

...........

and i need to exctract the IDs which  have different values of "type". In my case that would be id=101 and 103 but i got no clue how to approach it. Any hints  please?

Thx

[mohamed_zaki · Accepted solution]

proc sql ;
select id
from have 
group by id
having count(distinct type)>1
;
quit;

[Tal]

thanks Mohamed_zaki

completly forgot about  "distinct"

Thanks a lot!

[mohamed_zaki]

data want ;
set have;
by id;
retain ttype pflag;
if first.id then do;  ttype=type;  pflag=0; end;
else if (type ne ttype) and (pflag=0) then do; output; pflag=1;end;
keep id;
run;