Re: st: Need Help with Stata Programming

[Michael Stewart <michaelstewartresearch@gmail.com>]

Dear Nick ,

Thank you very much for the advice .I looked at the prior code, your
reference(took a print out) and read it and tried to solve the problem
at hand.


My Goal :
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).

I am trying to solve the problem with hints amd have been stuck up here

***************************************************************************
gen NUM_IP_PRIOR=.

qui forvalues i=1/`=_N'{
sum admit_type if admit_type==IP & Pt_id==Pt_id[`i']
replace NUM_IP_PRIOR=r(N) in `i'
}
*************************************************************************

I am able to get number of IP (inpatient admissions) for each patient
as a whole but not able to further break it down by
(i)before and after the event
(ii)60 days before the event(i.e., event==1) OR 60 days after the
event(i.e., event==1).[with a time component]

How could I add the condition/stata pseudocode so as to get count of
IP before the event(variable-1) OR after the event(variable-2)
.Please help.


Thank you very much for your time

On Wed, Nov 20, 2013 at 8:27 AM, Nick Cox <njcoxstata@gmail.com> wrote:
> A similar question was posted only yesterday
>
> http://www.stata.com/statalist/archive/2013-11/msg00745.html
>
> and advice included a reference
>
> SJ-7-3  pr0033  . . . . . . . . . . . . . .  Stata tip 51: Events in intervals
>         . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
>         Q3/07   SJ 7(3):440--443                                 (no commands)
>         tip for counting or summarizing irregularly spaced
>         events in intervals
>
> which is accessible at http://www.stata-journal.com/sjpdf.html?articlenum=pr0033
>
>
> Nick
> njcoxstata@gmail.com
>
>
> On 20 November 2013 13:11, Michael Stewart
> <michaelstewartresearch@gmail.com> wrote:
>
>> 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).
>
>
>> 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
> *
> *   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/



-- 
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/