Oh, I almost forgot the third way. Sorry. data have;
input date :yymmdd10. time : time9. value ;
format date date. time time.;
cards;
20010101 16:33:35 1
20010101 16:33:35 3
20010101 16:33:35 3
20010101 16:33:35 6
20010101 16:33:38 1
20010101 16:33:38 2
20010101 16:33:38 6
;
run;
proc summary data=have;
by date time;
var value;
output out=want median=median;
run;
Xia Keshan
... View more