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.
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...
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.