st: Analysis admissions after liver transplant

["Dudekula, Anwar" <dudekulaan@upmc.edu>]

Hi, 

I am here with posting a de-identified data for patients with liver transplant 

--The patients  with liver disease get admitted multiple times to the hospital.During one of the admission, they get liver transplant based on their degree of sickness.They can get re-admitted to the hospital after liver transplant for  complications related to transplant.To explore this issues, we want to evaluate the admissions after they get the liver transplant 

--For example  patient with pseudoid-1 gets liver transplant in 4th quarter .That patient gets admitted three times subsequently but patient with pseudiid-9 gets liver transplant during second admission and has three successive admissions after that 

--So I want to pick up the observations after the liver transplant( eventhough they may not get a liver transplant during that admission) 


The data contains 
--pseudoid, whcih is unique for the patient 
--sysid is unique for each quarter of a year 
--Q1,Q2,Q3,Q4 are 4 quarters of the year 

 

 	pseudoid     sysid   year    quarter     livertransplant |
     |------------------------------------------------------------|
  1. | pseudoid-1   0220890   2008         Q4    yes              |
  2. | pseudoid-1   0229499   2009         Q2	 no           |
  3. | pseudoid-1   0234526   2009         Q3    no 		  |
  4. | pseudoid-2   0234997   2010         Q2    no		  |
  5. | pseudoid-3   0248508   2008         Q1   yes 		  |
     |------------------------------------------------------------|
  6. | pseudoid-4   0227009   2008         Q2   no 		  |
  7. | pseudoid-4   0483263   2008         Q3   yes 		  |
  8. | pseudoid-5   0483419   2008         Q2   no		  |
  9. | pseudoid-6   0228531   2008         Q1   yes 		  |
 10. | pseudoid-7   0227324   2009         Q3   no 		  |
     |------------------------------------------------------------|
 11. | pseudoid-9   0227325   2008         Q1   no		  |
 12. | pseudoid-9   0227326   2008         Q2   yes 		  |
 13. | pseudoid-9   0227327   2008         Q3   no		  |
 14. | pseudoid-9   0482471   2008         Q4  	no		  |
 15. | pseudoid-9  0231492    2009         Q2   no 		  |



How do I about it .Please let me know

Yours sincerely 
Anwar 
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/