☆─────────────────────────────────────☆
Carlsberg (Carlsberg) 于 (Thu Jun 5 17:07:28 2008) 提到:
data 格式如下
id date time V
a 20070301 1 10
a 20070301 2 10.1
a 20070301 3 .
a 20070301 4 .
a 20070301 5 10.5
.
.
.
a 20070301 78 10.6
a 20070302 1 10.5
.
a 20070302 78 10.5
..
b 20070302 1 11.5
b 20070302 2 11.6
....
n********i 发帖数: 36
2
can you tell us how you solve the problem?
A*********u 发帖数: 8976
3
**先sort by id date time;
data locf;
set olddata;
by id date time;
retain lastnmis; ** means last no-missing value;
if first.date then lastnmis=.;
if v>.z then lastnmis=v;
else v=lastnmis;
run;
之后如果还有missing, 删掉就是了
can you tell us how you solve the problem?
【在 n********i 的大作中提到】 : can you tell us how you solve the problem?
