Once the acc becomes delinquent stop checking and "retain" true. data acc; input Date:date. Accno:$3. Delinquent; format date date9.; cards; 30Nov2011 123 0 31Dec2011 123 1 31Jan2012 123 0 30Nov2011 234 0 31Dec2011 234 0 30Nov2011 235 1 31Dec2011 235 1 ;;;; run; data deliq; flag = 0; do until(last.accno); set acc; by accno; if not flag then flag = ifn(Delinquent,1,0); output; end; run;
... View more