topic Re: Need to define a flag variable whether an incident has started within the first 24 hours of the in SAS Programming

Need to define a flag variable whether an incident has started within the first 24 hours of the sdat

noda6003 — Thu, 17 Jan 2019 09:51:36 GMT

I need to create a flag defining whether an incident has started within the first 24 hours of the sdate.

something like below

any help on how to do it

sdate incident flag

04DEC2018 05DEC2018 Y

08JAN2018 03JAN2018 N

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

PeterClemmensen — Thu, 17 Jan 2019 09:54:53 GMT

Are you working with date or datetime values?

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

ChrisNZ — Thu, 17 Jan 2019 09:56:03 GMT

Like this?

FLAG = ifc(-1 <= SDATE-INCIDENT <= 1, 'Y', 'N');

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

noda6003 — Thu, 17 Jan 2019 09:57:55 GMT

i have both date and datetime variables, datetime is character variable something like "2018-12-05T12:00" .

datetime makes sense to calculate flag if i am not wrong.

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

noda6003 — Thu, 17 Jan 2019 10:58:58 GMT

sorry if it is datetime like below than how to do?

sdate incident flag

04DEC2018T10:03 05DEC2018T09:03 Y

08JAN2018T13:03 03JAN2018T10:03 N

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

ChrisNZ — Thu, 17 Jan 2019 11:06:42 GMT

If you don't consider the time:

FLAG = ifc(-1 <= (input(SDATE,date9.) - input(INCIDENT,date9.)) <= 1, 'Y', 'N');

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

noda6003 — Thu, 17 Jan 2019 11:25:32 GMT

i want to consider time, can i do something like this?

FLAG = ifc(-1 <= (SDATE- INCIDENT) <= 1, 'Y', 'N');

Re: Need to define a flag variable whether an incident has started within the first 24 hours of the

Kurt_Bremser — Thu, 17 Jan 2019 12:44:44 GMT

With datetimes:

data have;
input sdate :e8601dt19. incident :e8601dt19.;
format sdate incident e8601dt19.;
cards;
2018-12-04T10:03 2018-12-05T09:03
2018-01-08T13:03 2018-01-03T10:03
;
run;

data want;
set have;
flag = ifc(0 <= intck('dtday',sdate,incident,'c') <= 1,'Y','N');
run;

proc print data=want noobs;
run;

Result:

sdate                  incident               flag

2018-12-04T10:03:00    2018-12-05T09:03:00     Y  
2018-01-08T13:03:00    2018-01-03T10:03:00     N