Like this? data HAVE (index=(DIF_DATE A=(ANALYST_CODE F_DATE)));
input F_DATE yymmdd9.
A_DATE yymmdd9.
F_VALUE
A_VALUE
ANALYST_CODE;
DIF_DATE = abs(A_DATE-F_DATE);
DIF_VALUE = A_VALUE-F_VALUE;
cards;
20010305 20021002 3 3.15 5
20011228 20021002 3.1 3.15 9
20020223 20021002 3.2 3.15 7
20020518 20021002 3.3 3.15 5
20020826 20021002 3.4 3.15 7
20021001 20021002 3.5 3.15 9
run;
data WANT;
set HAVE;
by DIF_DATE;
V1=DIF_VALUE;
set HAVE key=ANALYST_CODE;
V2=DIF_VALUE;
output;
stop;
run;
... View more