Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index