OK. data have;
input Time & anydtdtm20. Bid Ask ;
format time datetime.;
cards;
1/1/2013 12:00:00 1 1
1/1/2013 12:00:02 3 3
1/1/2013 12:00:06 1 2
1/1/2013 12:00:20 5 4
;
run;
proc summary data=have;
var time;
output out=m max=_max min=_min;
run;
data temp;
set m;
do time2=_min to _max;
output;
end;
format time2 datetime.;
keep time2;
run;
data want;
merge temp have;
run;
Ksharp
... View more