extract data when the variable in the group is different.

[France]

Dear all,

I want to create a new data set from the old data set when the variable in the group is different.

for example,

the old dataset

variable , group 

12, A
13, A

14,B

15,C

I would like to only keep 

the new dataset 

variable , group 

12, A
13, A

I try to use the code like 

DATA Sa_Step1.appln_new3;
   SET Sa_Step1.appln_new2;
   if count ( case group_name ) >1 ;
RUN;

but it doesn't work. could you please give me a suggestion ?

thanks in advance.

best ragards

[PeterClemmensen · Accepted solution]

data have;
input var group $;
datalines;
12 A
13 A
14 B
15 C
;

proc sql;
   create table want as 
   select * from have
   group by group
   having count(distinct var) > 1;
quit;