Hi, I have tested this code, may be somebody might have a better idea...... data have; Input accnt amnt date date9.; datalines; 1 100 1 120 1 120 1 130 1-Jan-14 1 130 1 150 2 0 2 0 2 0 2 1000 2-Mar-14 2 1000 2 1000 3 200 2-Mar-14 3 200 3 230 3 230 3 300 4 500 4 500 2-Mar-14 4 500 4 550 ; data want(keep=accnt,amnt,date); set have; if accnt = _accnt and _date ne . then do; date = _date; end; _accnt = accnt; _date = date; retain _accnt _date; data want; set want; if date ne .; proc means data=want; var amnt; class accnt; run; Result(Partial): ------------- N accnt Obs N Mean ----------------------------------- 1 3 3 136.6666667 2 3 3 1000.00 3 5 5 232.0000000 4 3 3 516.6666667 -----------------------------------
... View more