补时间观测

数据在   sheet1里    谢谢

1. proc sort have;
   
2.    by code date;
   
3. run;
   
4. 
   
5. data want;
   
6.    set have;
   
7.    by code date;
   
8.    time_lag = lag(time);
   
9.      if first.date then time_lag=time;
   
10.      time_dif = (time - time_lag)/5/60;
    
11.    if time_dif  > 1 then do;
    
12.      do i = 1 to time_dif;
    
13.       time = time_lag + 5*60*i;
    
14.       output;
    
15.      end;
    
16.    end;
    
17.    else  output;
    
18.    drop time_lag time_dif i;
    
19. run;

复制代码