h*******i 发帖数: 153 | 1 data two;
input id YN creds;
cards;
23 1 3.00
. 2 2.00
24 1 1.00
. 1 2.00
. 2 2.00
;
RUN;
I only have two id here, 23 and 24. How to use 23 to replace first missing
number, 24 to replace the next two numbers? | h******n 发帖数: 232 | 2 data three;
set two;
retain new_id;
if id ^= . then new_id = id;
run; |
|