topic Re: Keep 15 min pgstats in SAS Procedures

Keep only 15 min intervals

BETO — Mon, 14 Dec 2015 20:42:17 GMT

data t;
set t1 t2;
dt = dhms(date, hour(time), minute(time), second(time));
format dt datetime19. date date9. time time8.;
run;

proc sort data=t; by machine dt; run;

/* Drop records that are less than 15 min. from previous */
data want;
do until(last.machine);
set t; by machine;
if dt - '00:15:00't > lastDT then do;
output;
lastDT = dt;
end;
end;
drop lastDT;
run;

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

Re: Keep 15 min pgstats

LinusH — Mon, 14 Dec 2015 19:43:32 GMT

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.

Re: Keep 15 min pgstats

Reeza — Mon, 14 Dec 2015 20:28:10 GMT

Please don't direct your question to one person, but to the forum in general. That person may or may not have time to answer your question and it's meant to be a public forum.

Re: Keep 15 min pgstats

BETO — Mon, 14 Dec 2015 22:35:08 GMT

My mistake I was aware it was public the person help me with a same question I fig it was easy to address it to them ...