把上面的code改了一点.
如果需要还可以再 sort by name cishu 后重新运行这段程序。
proc sort data=a out=a_Dsort; by name descending cishu;
run;
data b;
set a_Dsort;
by name;
retain marry1;
if first.name then do;
if marry ne " " then marry1=marry;
else call missing(marry1);
end;
else do;
if missing(marry) then marry = marry1;
else marry1 ...
把上面的code改了一点.
如果需要还可以再 sort by name cishu 后重新运行这段程序。
proc sort data=a out=a_Dsort; by name descending cishu;
run;
data b;
set a_Dsort;
by name;
retain marry1;
if first.name then do;
if marry ne " " then marry1=marry;
else call missing(marry1);
end;
else do;
if missing(marry) then marry = marry1;
else marry1 = marry;
end;
drop marry1;
run;