data want;
set have;
ytime_new=DHMS(MDY(SUBSTR(ytime,5,2),SUBSTR(ytime,7,2),SUBSTR(ytime,1,4)),SUBSTR(ytime,9,2),SUBSTR(ytime,11,2),0);
rtime_new=DHMS(MDY(SUBSTR(rtime,5,2),SUBSTR(rtime,7,2),SUBSTR(rtime,1,4)),SUBSTR(rtime,9,2),SUBSTR(rtime,11,2),0);
run;
我来补全,希望能抛砖引玉!
data time1;
set time;
ytime1=dhms(mdy(substr(ytime,5,2),substr(ytime,7,2),substr(ytime,1,4)),substr(ytime,9,2),substr(ytime,11,2),0);
rtime1=dhms(mdy(substr(rtime,5,2),substr(rtime,7,2),substr(rtime,1,4)),substr(rtime,9,2),substr(rtime,11,2),0);
days=int((rtime1-ytime1)/(60*60*24));
hours=int((mod((rtime1-ytime1),(60*60*24))/(60*60)));
run;