topic Re: Group By in SAS Procedures

Group By

LearnByMistk — Mon, 06 Apr 2015 07:18:48 GMT

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;

Re: Group By

Ksharp — Mon, 06 Apr 2015 07:48:16 GMT

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

Re: Group By

LearnByMistk — Mon, 06 Apr 2015 10:15:30 GMT

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