Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Need Help with Stata Programming
From
Michael Stewart <[email protected]>
To
statalist <[email protected]>
Subject
st: Need Help with Stata Programming
Date
Wed, 20 Nov 2013 08:11:25 -0500
Hi Everyone,
I am trying to measure number of visits/admissions before and after a
particular event and was hoping to get help from Stata programmers in
the Statalist
My dataset is as follows . ED: stands for emergency department visit &
IP stands for Inpatient admission
Patients are sorted chronologically (by date).
My goal is
1)Count number of admissions(i.e., admit_type==IP) 60 days before the
event(i.e., event==1) OR 60 days after the event(i.e., event==1).
2)Sum up the cost of the admissions (i.e., admit_type==IP) 60 days
before the event(i.e., event==1) OR 60 days after the event(i.e.,
event==1).
Can you please help me . Usually, I try myself and shows the code to
the statalist members but here , in this case, I am not sure, where to
start.Sorry.
Pt_id || admit_type || event || Date || Cost
_______________________________________________________
1 ED 0 date_1 USD xx
1 ED 0 date_2 USD xx
1 IP 0 date_3 USD xx
1 IP 1 date_4 USD xx
1 IP 0 date_5 USD xx
1 IP 0 date_6 USD xx
--------------------------------------------------------
2 ED 0 date_1 USD xx
2 IP 1 date_2 USD xx
2 ED 0 date_3 USD xx
2 IP 0 date_4 USD xx
2 ED 0 date_5 USD xx
2 ED 0 date_6 USD xx
2 IP 0 date_7 USD xx
--------------------------------------------------------
3 ED 0 date_1 USD xx
3 IP 0 date_2 USD xx
3 ED 0 date_3 USD xx
3 IP 0 date_4 USD xx
3 IP 1 date_5 USD xx
3 ED 0 date_6 USD xx
3 IP 0 date_7 USD xx
3 ED 0 date_8 USD xx
Thank you very much for your time.
--
Thank you ,
Yours Sincerely,
Mike.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/