topic Re: Conditional operation with TIME in New SAS User

Conditional operation with TIME

d6k5d3 — Fri, 07 Dec 2018 04:49:06 GMT

I have a dataset as the one below:

Date Day Time yyy zzz

3/17/2009 Fri 9:00:00 12 34

5/18/2013 Fri 10:00:00 23 34

7/21/2007 Fri 11:45:00 45 56

…..……………………………..

Now, I would like to filter data with Time. The Time is in NUM time20. format. I would like to do this:

if day is FRI and time between 9:00:00 and 11:00:00 then ssss=aa;

I coded as: if day="Fri" and 9:00:00<Time<11:00:00 then ssss=aa; which gives an error and asks for arithmetic operator.

I need your help!

Much thanks.

novinosrin — Fri, 07 Dec 2018 04:51:36 GMT

try

if day="Fri" and '9:00:00't<Time<'11:00:00't then ssss=aa;

this assumes aa is variable name

PGStats — Fri, 07 Dec 2018 04:53:16 GMT

You were close, you must use time literals :

if day="Fri" and '9:00:00't<Time<'11:00:00't then ssss=aa;

novinosrin — Fri, 07 Dec 2018 04:59:03 GMT

@PGStats Sir, it's nothing to hide that I adore you, but we seem to have a great connection. 🙂 like last night.

PGStats — Fri, 07 Dec 2018 05:24:13 GMT

Cheers!