Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Re: Request code simplification


From   Michael Stewart <michaelstewartresearch@gmail.com>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   st: Re: Request code simplification
Date   Tue, 11 Jun 2013 17:14:39 -0400

Hello,

I am  working on a data set with thousands of patients( and multiple
records per patient) and I am trying to identify pateints with any
transplant(could undergo liver, kidney, intestine etc) . I was
wondering if we could simplify my  code as my laptop is freezing with
the following set of commands.


Here the goal is find patients who has
type_of_visit[1]=="first_clinic_visit" & any other type_of_visit is
"".(after the records are sorted by pat_id and visit_date)

My code :

bysort PAT_ID (visit_date):carryforward VISIT,gen(v)
bysort PAT_ID (visit_date):gen x=v[1]==v[_n]
bysort PAT_ID (visit_date):egen z=sum(x)
bysort PAT_ID (visit_date):egen zz=count(x)
gen y= z< zz


The dataset format is as follows.

pat-id     visit_date     type_of_visit
-------------------------------------------------------
xxx      09/01/2003      first_clinic_visit
xxx      09/15/2003
                .
                .
                .
                .
XXX      12/12/2003
XXX      2/04/2004       liver_transplant
yyy      01/01/2004      first_clinic_visit
yyy      02/02/2005
                 .
                  .
yyy     01/03/2008      intestine_transplant
zzz      05/01/2010     first_clinic_visit
zzz     05/03/2011
                  .
                  .
                  .
                  .
------------------------------------------------------------

As always, thanks a lot 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index