It's an option in PROC FREQ.  *See The FREQ Procedure and Example 47.4 Binomial Proportions      Here's a usage with your data:   data have; input ID @3 test $1.; datalines; 1 Y 2 Y 3 N 4 5 6 N 7 N run; proc freq data=have; tables test / binomial (clopperpearson) ; run;   ... View more

If you have variables named JUNE and JULY just take the MIN of them by ID. proc summary data=have; by id; var june july; output out=want min= ; run; If that is not how your data is actually structured then show a more representative example of the data you actually have. ... View more

One way is to use RENAME= option. data want; set have have(rename=(firstName=lastName lastName=firstName)); run; ... View more

proc summary data=have nway; class id; var price; output out=flag min=min max=max; run; data want; merge have flag; by id; if min=10 and max=10 then same_price_equal_to_10=1; else same_price_equal_to_10=0; drop min max; run; ... View more

Hi there, you are correct, the data should not go from 1 to 0, is should only go from 0 to 1... I guess it's a manual error when recording. I just want to check the overall data quality... when there is data go from 1 to 0, I need to what are the IDs for them, so I could manually check on them again. But I need a list of IDs at least...I don't want to check on every equipment. ... View more