topic Re: Data Step in SAS Procedures

Data Step

Tal — Tue, 23 Feb 2016 00:06:24 GMT

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

Re: Data Step

mohamed_zaki — Tue, 23 Feb 2016 00:32:32 GMT

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

Re: Data Step

mohamed_zaki — Tue, 23 Feb 2016 00:55:27 GMT

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;

Re: Data Step

Tal — Tue, 23 Feb 2016 01:21:25 GMT

thanks Mohamed_zaki

completly forgot about "distinct"

Thanks a lot!