topic Re: Applying filter in TIME variable. in SAS Programming

Applying filter in TIME variable.

pappusrini — Mon, 14 May 2018 20:46:23 GMT

Hello,

I'm trying to extract the data by applying filter between 8AM to 6PM in data set. Time variable is in TIME format. Any suggestions please?

Thanks in advance

Cnu

Re: Applying filter in TIME variable.

novinosrin — Mon, 14 May 2018 20:50:52 GMT

where time between '8:00't and '6:00pm't;

Re: Applying filter in TIME variable.

Reeza — Mon, 14 May 2018 20:51:32 GMT

Where time between ‘06:00’t and ‘18:00’t;

Note the t after the time to indicate a time value.

Re: Applying filter in TIME variable.

pappusrini — Mon, 14 May 2018 21:26:00 GMT

Thanks. Does it matter if the time variable is the “time part” of date/time variable?

I have the time variable as:

8Am
9Am

But this is the time part of date/time variable.

Thanks

Re: Applying filter in TIME variable.

Reeza — Mon, 14 May 2018 21:26:40 GMT

@pappusrini wrote:
Thanks. Does it matter if the time variable is the “time part” of date/time variable?

I have the time variable as:

8Am
9Am

But this is the time part of date/time variable.

Thanks

Try it.