topic Referencing Time Values to Create a Group in SAS Programming

Referencing Time Values to Create a Group

shellp55 — Thu, 16 Jun 2016 15:46:41 GMT

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.

Re: Referencing Time Values to Create a Group

PGStats — Thu, 16 Jun 2016 17:03:29 GMT

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

Re: Referencing Time Values to Create a Group

shellp55 — Thu, 16 Jun 2016 17:11:48 GMT

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!