Hi Everyone,
I have a data manipulation question. I have a large data set (panel
format) and I am trying to calculate length of stay for each individual.
The thing is many individuals come in (adm asses) and stay then leave
(disch) then come back. But to complicate it more, some people leave
with anticipated return (dis_ret) then come back (reentry) and some
people are admitted and have follow up but have not been discharged.
What I would like to do is create a variable that has LOS for each
separate admission. Below is a sample of my data
resident target aa8a LOS (what I want to
create)
1 30sep2001 adm asses 0
1 10oct2001 disch 10
1 18nov2002 adm asses 0
1 22nov2002 disch 4
1 18jul2004 adm asses 0
1 28jul2004 disch 10
2 07may2003 adm asses 0
2 20jul2003 quart review 74
2 12oct2003 quart review 158
2 04jan2004 quart review 242
2 28mar2004 ann asses 326
2 20jun2004 quart review 410
2 12sep2004 quart review 494
3 15oct2000 adm asses 0
3 23oct2000 dis_ret 8
3 25oct2000 reentry 0
3 22nov2000 disch 28
4 17oct2000 adm asses 0
4 01nov2000 disch 15
5 15oct2000 adm asses 0
5 22nov2000 disch 38
I created a flag for any type of discharge and I think if I create a
unique id for each admission that I would be able to calculate the LOS.
I'm just not sure how to get this admission id or whether there is
another way I could do this.
Any help would be greatly appreciated.
Cheers,
Bellinda
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
