Referencing Time Values to Create a Group

[shellp55]

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.

[PGStats · Accepted solution]

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

[shellp55]

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!