Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

st: Re: Request code simplification

From   Michael Stewart <>
To   statalist <>
Subject   st: Re: Request code simplification
Date   Tue, 11 Jun 2013 17:14:39 -0400


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,
*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index