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: Re: Request code simplification
From
Michael Stewart <[email protected]>
To
statalist <[email protected]>
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/