Hey there, I have an SQL approach if you're so inclined: data data_have; infile datalines dsd dlm="," missover; input Company : $char1. Date : MMDDYY10. IC : $char4. ACCT : $char4. ID : 8. ; datalines; A,01/01/2006,YES,,100 A,01/05/2006,YES,,100 A,01/10/2006,,,100 B,07/15/2006,,YES,110 B,07/21/2006,,YES,110 B,07/25/2006,,,110 B,07/30/2006,,,110 C,10/01/2006,,,115 C,10/21/2006,,,115 ; run; proc sql; create table data_want as select a.* from data_have as a, (select distinct Company from data_have where IC='YES' or ACCT='YES') as tmp where a.Company = tmp.Company; quit; Thanks, Huey
... View more