Hi everyone...does anyone know how should i modify my coding to get result that generates after d_DELQ_BUCKET2=74, the next row must be d_DELQ_BUCKET2=73,...72,...71 and so on. However the example here only one sample from 90,000 records. Appreciate if the coding can applicable to large records. Thanks a lot My coding: Data a; Set b; by acct_number; If first. acct_number then d_DELQ_BUCKET=DELINQUENCY_BUCKET; else d_DELQ_BUCKET+(-1); d_DELQ_BUCKET2=max(DELINQUENCY_BUCKET, d_DELQ_BUCKET) run;
... View more
