A unique admission id is
bysort resident (time) :
gen adm_id = sum(inlist(aa8a, "adm asses", "reentry"))
Then los sounds like
bysort resident adm_id (time) :
gen los = time - time[1]
Nick
[email protected]
Kallimanis, Bellinda
> 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.
*
* 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/
