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;
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
got it by my own ....thanks for your effort
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.