DATA Step, Macro, Functions and more

Referencing Time Values to Create a Group

Accepted Solution Solved
Reply
Regular Contributor
Posts: 152
Accepted Solution

Referencing Time Values to Create a Group

Hi

 

I have some hospital data and want to create a field of "Shifts" based on the registration time.  I created the time by using "timepart(regdttm).

 

For shift I specified the length as 15 and used the code: 

if admhour ge '7:00't  and admhour le '17:00't then shift="0700 to 1700 hours";

 

This doesn't produce an error but doesn't have anything showing in the "shift" column even though there are cases that should be.  I also tried leaving the time in its SAS format and entered as a number but that didn't work either.

 

All assistance greatly appreciated.   Thanks.


Accepted Solutions
Solution
‎06-16-2016 01:11 PM
Respected Advisor
Posts: 4,659

Re: Referencing Time Values to Create a Group

The error is not in the code shown, it most likely reside at or prior to the calculation of admHour. Please post more.

PG

View solution in original post


All Replies
Solution
‎06-16-2016 01:11 PM
Respected Advisor
Posts: 4,659

Re: Referencing Time Values to Create a Group

The error is not in the code shown, it most likely reside at or prior to the calculation of admHour. Please post more.

PG
Regular Contributor
Posts: 152

Re: Referencing Time Values to Create a Group

Duh, stupid mistake on my part - the Ahour formula was before the field of regdttm had been created so once I put the shift after the field existed it worked.

 

Thanks so much PG Stats! 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 186 views
  • 0 likes
  • 2 in conversation