Same idea but uses MIN function'
Data have;
Input Customer_ID $ Date :mmddyy8. Numeric_Value;
format date mmddyy8.;
cards;
ABC123 12/31/17 80
ABC123 3/31/18 90
ABC123 6/30/18 75
ABC123 9/30/18 100
ABC123 12/31/18 110
DEF456 12/31/17 50
DEF456 3/31/18 40
DEF456 6/30/18 55
DEF456 9/30/18 60
DEF456 12/31/18 35
run;
data want(rename=(n=Numeric_Value));
do until(last.customer_id);
set have;
by customer_id;
n=min(Numeric_Value , n);
output;
end;
drop Numeric_Value;
run;
... View more
