@Tom  I'm always impressed how you second guess the actual wants/needs from very vaguely worded questions, and even try to provide a full answer based on these guesses. ... View more

I have included Kurt's solution in "SQL execute" transformation. In the job, this transformation is performed first. This solution works. However, if the job crashes, the variable is no longer available and the first step must be performed again. ... View more

Hello Kurt, May I again appeal to you for your SAS knowledge. In nursing, we use three daily rosters for the nurses. Now we would like to split the length of stay on the ward per calendar day into the duration of stay per roster. This is quite a puzzle since the length of stay can start in roster1 and end in roster2 or start in roster1 and also end in roster1 etc. etc.. Maybe you have a suggestion, idea or solution. Thanks in advance for your response.   Roster1 23:30 until 07:30 (>23:30 <=07:30) (duration 8 hours --> 30 minutes until midnight and 450 minutes until start roster2)  Roster2 07:30 until 15:30 (>07:30 <=15:30)  (duration 8 hours) Roster3 15:30 until 23:30 (>15:30 <=23:30)  (duration 8 hours)   data_input desired output ... View more