topic Re: Length Of Stay in SAS Programming

Length Of Stay

Samsami — Wed, 28 Feb 2018 00:14:01 GMT

Hello,

how to calculate the length of stay for a group of patients using SQL query, I do have a table which contain Patient Id, Date of admission, date of discharge.

Appreciate your help.

Re: Length Of Stay

ChrisBrooks — Wed, 28 Feb 2018 01:18:45 GMT

This should be straightforward because SAS dates are just formatted numbers so subtracting one from the other should give you the length of stay. However if you want something more precise you'll have to give us more details - check out this post for how to frame your question so we can help you better (in particular we'd need some sample data). https://communities.sas.com/t5/SAS-Support-Communities/How-to-ask-a-good-question-and-receive-a-fast-reply/ta-p/417192

Re: Length Of Stay

PGStats — Wed, 28 Feb 2018 02:00:41 GMT

If your dates are SAS dates then the SQL column expression should be

intck("day", admissionDate, dischargeDate) + 1 as lengthOfStay

+ 1 is assuming that a patient admitted and discharged on the same day will have a length of stay of 1 day.