12-14-2015 02:36 PM - last edited on 12-14-2015 03:42 PM by ChrisHemedinger
set t1 t2;
dt = dhms(date, hour(time), minute(time), second(time));
format dt datetime19. date date9. time time8.;
proc sort data=t; by machine dt; run;
/* Drop records that are less than 15 min. from previous */
set t; by machine;
if dt - '00:15:00't > lastDT then do;
lastDT = dt;
Hi pgstats. How would it look like if I wanted to keep everything within 15min? ... If it was greater than 15 min drop.. Table one columns would be machine time date. Table 2 machine start date end date duration time
12-14-2015 02:43 PM
Believe it or not, but all community visitors can see this message.
If you wish to send a personal/direct/private message, go to that persons profile, and click on "Send this user a private message", in the "Contact me" box to right.
Need further help from the community? Please ask a new question.