I think this might be passed to the underlying database to do the work: proc sql; create table want as select Record_Number, Min(dos) as First_DOS, max(case when dos>='01jan2006:0:0'dt and dos < '01Jan2007:0:0'dt then 1 else 0 end) as DOS_2006, max(case when dos>='01jan2007:0:0'dt and dos < '01Jan2008:0:0'dt then 1 else 0 end) as DOS_2007 from have group by record_number; quit;
... View more
