LZ,程序有点长,希望能帮到你...
data a;
input x $19.;
cards;
2011-09-01 14:20:31
2011-09-01 17:19:06
;
run;
data b;
set a;
informat recordtime2 datetime19.;
format recordtime2 datetime19.;
recordtime2=input(scan(x,1,' '),yymmdd10.)*24*60*60+input(scan(x,2,' '),time8.);
run;
proc means data=b;
var recordtime2;
output out=c(keep=min) min=min;
run;
data d;
set c;
z=compress(put(min,b8601dt.),'T');
time=cat(put(datepart(min),yymmdd10.)," ",substr(strip(z),9,2),":",substr(strip(z),11,2),":",substr(strip(z),13,2));
run;
Found problem, just change
b=input('2011-09-01 14:20:31', b8601dt.); to
b=input('2011-09-01 14:20:31', IS8601dt.); That's OK.
可~乐 is great, misaligned your finger on keyboard perhaps.