data a;
input Stkcd Date yymmdd8. Clpr Stkdrate Capissurate RigoffrateRigoffpr Snirate Snipr Dividend;
format Date mmddyy8.;
cards;
600001 01-01-01 8 . . . . .. .
600001 01-01-02. 0.3 0.3 0 0 0 0 0
600001 01-01-03 9 0 0 0.50.2 0 0 0.1
600002 01-01-02 10 0 0 0 0 00 0
600002 01-01-03. 0.2 0.3 0.5 0 0 0.1 0.2
600002 01-01-04 12 0 0 0 0.20.3 0.5 0.6
;
run;
要把Clpr缺失的观测中后面的数值(即0.3 0.3 0 0 0 0 0)合并(求和)到下一个观测(0 0 0.5 0.2 0 0 0.1),求大神指教。