Programming the statistical procedures from SAS

Time Query Question

Occasional Contributor
Posts: 16

Time Query Question

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.


Respected Advisor
Posts: 5,056

Re: Time Query Question

time = timepart(StartTime);

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


Occasional Contributor
Posts: 16

Re: Time Query Question

Thanks a bunch~!

Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 2 in conversation