Group By

[LearnByMistk]

data have;  input acc$ sub accs$  ;  cards;  a 1 d  a 2 d  a . a  a . d  b 3 a  b 4 d  c . a  d . a ; run;

data want ;

c . a;

d .a;

run;

proc sql;

  select count(acc),acc from test where sub is  null group by acc ;

  quit;

[Ksharp]

You don't explain your question yet .

data test;  
input acc $ sub accs $ @@;
cards;  
a 1 d  a 2 d  a . a  a . d  b 3 a  b 4 d  c . a  d . a 
;
run;

 
proc sql;
  select * from test where sub is  null group by acc having count(*) eq 1  ;
  quit;

Xia Keshan

[LearnByMistk]

got it by my own ....thanks for your effort