RE: st: Need Help with Datamanagement and Survival analysis

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

Dear Prakash , 
When I use & ,I will still end up with a list like the following 
Pt Name  Date          Type of Encounter
--------------------------------------
pt y    12-Jul-11       Telephone
pt y    13-Jul-11       Telephone
pt y    14-Jul-11       Telephone
pt y    15-Jul-11       Telephone
pt y    16-Jul-11       Telephone
pt y    17-Jul-11       Telephone
pt y    19-Jul-11       Inpatient

The goal is to get two consecutive observations for each patient where the Type of encounter is Telephone and next observation id Inpatient.

Thank you,
Yours Sincerely,
Anwar

________________________________________
From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] on behalf of Prakash Singh [prakashbhu@gmail.com]
Sent: Sunday, December 02, 2012 1:03 AM
To: statalist
Subject: Re: st: Need Help with Datamanagement and Survival analysis

Dear Anwar, I think you just need to use & in place of | in your command.



Prakash

On Sun, Dec 2, 2012 at 11:11 AM, Dudekula, Anwar <dudekulaan@upmc.edu> wrote:
> Hi,
>
> I need help with stata code
>
> In the following dataset :
>
> Telephone : Is a phone call made by the patient.
> Office Visit: is a clinicl visit
> Inpatient: is admission to hospital
>
> I am trying to find a set of patients in whom a Telephone(Type of Encounter)is followed by Inpatient(Type of Encounter) without any interspread Office Visit
>
> My stata code was keep if (Type of Encounter=="Telephone"|Type of Encounter=="Inpatient") but I got lot of observations with successive telephone calls followed by inpatien.
>
> I only want to see only those observations if a telephone is followed by Inpatient(event) or only telephone(censored) ; Is there  a stata code for it .
>
> In next step, is there any stata macro to convert that to survival dataset format if failure= havig inpatient admission after telephone call in observed timeperiod(year 2011)
>
>
>
> Pt Name  Date         Type of Encounter
> --------------------------------------
> pt x    4-Apr-11        Office Visit
> pt x    20-May-11       Telephone
> pt x    12-Jun-11       Inpatient
> pt x    15-Jun-11       Office Visit
> pt x    8-Aug-11        Inpatient
> pt y    12-Jul-11       Telephone
> pt y    13-Jul-11       Telephone
> pt y    14-Jul-11       Telephone
> pt y    15-Jul-11       Telephone
> pt y    16-Jul-11       Telephone
> pt y    17-Jul-11       Telephone
> pt y    19-Jul-11       Inpatient
> pt y    4-Aug-11        Office Visit
> pt y    4-Sep-11        Telephone
>
> I would really appreciate the help .
> Thank you .
>
> Sincerely
> Anwar
>
>
> *
> *   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/


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