Time Query Question

Yondori — Thu, 03 Jan 2013 12:53:57 GMT

Hi I always appreciate this community and thank you for users who gave me generous tips on my SAS problem.

I have a little problem on my SAS coding and I want your generous advice on this problem.

I have a dataset as follows..

And I want to see the data which is recorded BETWEEN 6:30 AM ~ 9:30 AM (Commuting Time).

So I put new variable as 'Time' like this

Data app_total0; set app_total;

time=starttime; format time timeampm.; run;

and now the time variables are shown in the dataset as I expected

But, the problem is that I don't know how to query the data which is recorded between 6:30 am ~ 9:30 am ..

please give me some tips on this problem.

Thanks

Re: Time Query Question

PGStats — Thu, 03 Jan 2013 13:20:30 GMT

time = timepart(StartTime);

if time >= '06:30:00't and time <= '09:30:00't;

Yondori — Fri, 04 Jan 2013 00:45:24 GMT

Thanks a bunch~!