topic Re: Subsetting dataset based on time in SAS Programming

Subsetting dataset based on time

lalaktgrau — Mon, 15 Oct 2018 04:06:46 GMT

Hi,

How do I subset data based on a time variable? The variable has the time format which makes it look like "21:36:00." I want anyone between 7pm and 12pm?

Num

TIME.

Re: Subsetting dataset based on time

novinosrin — Mon, 15 Oct 2018 04:35:53 GMT

use time constant

where time_variable between '7:00pm't and '12:00pm't;

Re: Subsetting dataset based on time

Kurt_Bremser — Mon, 15 Oct 2018 12:51:53 GMT

12 pm is (per definition) noon, so your rule would include everything from 19:00 on one day to 12:00 on the next.

I rather guess you want to include everything between '19:00:00't and '24:00:00't;

Re: Subsetting dataset based on time

lalaktgrau — Mon, 15 Oct 2018 18:20:36 GMT

Do you know if there is a way to combine a date variable and a time variable to create a Datetime variable?

Re: Subsetting dataset based on time

Kurt_Bremser — Mon, 15 Oct 2018 18:48:13 GMT

@lalaktgrau wrote:

Do you know if there is a way to combine a date variable and a time variable to create a Datetime variable?

The dhms() function. Use the date as the first and the time as the fourth parameter; set the second and third parameter to zero.