Programming the statistical procedures from SAS

Time Query Question

Reply
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..

1.png

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

2.png

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

Respected Advisor
Posts: 4,606

Re: Time Query Question

time = timepart(StartTime);

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

PG

PG
Occasional Contributor
Posts: 16

Re: Time Query Question

Thanks a bunch~!

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