extract data when the variable in the group is different.

France — Tue, 11 Sep 2018 12:42:59 GMT

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

Re: extract data when the variable in the group is different.

PeterClemmensen — Tue, 11 Sep 2018 12:47:06 GMT

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;

topic Re: extract data when the variable in the group is different. in SAS Programming

extract data when the variable in the group is different.

Re: extract data when the variable in the group is different.