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]
Re: st: Need Help with Stata Programming
From
Michael Stewart <[email protected]>
To
statalist <[email protected]>
Subject
Re: st: Need Help with Stata Programming
Date
Thu, 21 Nov 2013 09:44:28 -0500
HI Fabrizio,
I am working on your recommendations. Will keep you posted
On Wed, Nov 20, 2013 at 8:36 AM, Fabrizio Colella - 1348010
<[email protected]> wrote:
> Hi,
>
> 1) I suggest you to create first a variable "period" that identify if the "Date" is before, in the middle, of after the 60 days,
> and after count using the command -tab admit_type period-.
>
> 2) here you can first create two dummies, assuming values 1 if the admin=="IP" and period==... (depend the values of the variable created at the first stage) and after -egen newvar = total(cost) if dummy1==1 (and the same for dummy2).
>
> I hope I understood what you were looking for...
>
> Cheers
>
> Fabrizio
>
> ------------------------------------------
>
> Fabrizio Colella
> Bocconi University and
> Fondazione Rodolfo DeBenedetti
> Milan, Italy
> [email protected]
>
> ----- Original Message -----
> From: "Michael Stewart" <[email protected]>
> To: "statalist" <[email protected]>
> Sent: Wednesday, November 20, 2013 2:11:25 PM
> Subject: st: Need Help with Stata Programming
>
> 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/
> *
> * 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/