How to do distinct count of ID across variables

[d0816]

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

[PaigeMiller · Accepted solution]

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

[d0816]

Thank  you Paige.