Hi Thank you for getting back to me. My dataset has only treatment in it but there are gap in the months that the subject receives drug and i need only those subjects who have remained on drug 100 % after they have come back from the gap. DATA HAVE; INFILE DATALINES DELIMITER=','; INPUT USUBJID $ MONTH $ TREATMENTS $; DATALINES; USUBJID1,01,DRUG USUBJID1,02,drug USUBJID1,04,DRUG USUBJID2,05,DRUG USUBJID2 06,DRUG USUBJID1,10,DRUG USUBJID1,11,DRUG USUBJID1,12,DRUG USUBJID2,10,DRUG USUBJID2,11,DRUG USUBJID2,12,DRUG ; RUN; From from the dataset above as you see all trt is same but i want only from the count of subjied from week 10-12 as well as subjid 2 from week 10-12 only. Thankx a lot
... View more