06-16-2016 11:46 AM
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.
06-16-2016 01:11 PM
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!
Need further help from the community? Please ask a new question.