topic How to do distinct count of ID across variables in New SAS User

How to do distinct count of ID across variables

d0816 — Wed, 10 Apr 2019 21:28:42 GMT

HI,

I have following dataset where I want to do a unduplicated count of ID if During or After is a "yes". With this logic unduplicated ID count that satisfy this condition is 8. would appreciate any help. Thanks.

ID	During	After
1		Yes
2		Yes
2		Yes
2		Yes
2		Yes
3
3		Yes
3
3		Yes
4
4		Yes
4	Yes
4	Yes
5
6		Yes
7
8	Yes
8	Yes
9
9		Yes
9		Yes
10
10
11	Yes
12

Re: How to do distinct count of ID across variables

PaigeMiller — Wed, 10 Apr 2019 21:31:00 GMT

proc sql;
    select count(distinct id) from have where during="Yes" or after="Yes";
quit;

Re: How to do distinct count of ID across variables

d0816 — Thu, 11 Apr 2019 13:23:03 GMT

Thank you Paige.