Thanks to all of you for your response. Jens and Renate, the syntax worked perfectly.
Walter
On Tue, Sep 30, 2014 at 8:00 PM, epidata-list-request@lists.umanitoba.ca wrote:
Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list ___________________________________
Today's Topics:
- RE: EpiData-list Digest, Vol 130, Issue 7 - count number of records (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Mon, 29 Sep 2014 17:26:21 +0000 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] RE: EpiData-list Digest, Vol 130, Issue 7 - count number of records To: "'epidata-list@lists.umanitoba.ca'" epidata-list@lists.umanitoba.ca Message-ID: FE3BD206B1C952409F1892C47023A625AF98A1@PDHU-EXCHANGE1.pdhu.on.ca Content-Type: text/plain; charset="us-ascii"
Hi Walter,
You could create a count of the number of records per unique individual and then select the first record:
Sort idunique visitdate
gen i count = 1 Var Name count of type Integer and length: 9 decimals 0 if idunique = idunique[_n-1] then count= count[_n-1] + 1 count= count[_n-1] + 1 the [_n] indicates recnumber and by subtracting one "_n-1" we get the previous record
select if count=1
Hope this helps,
Renate
-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto: epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request@lists.umanitoba.ca Sent: Monday, September 29, 2014 1:01 PM To: epidata-list@lists.umanitoba.ca Subject: EpiData-list Digest, Vol 130, Issue 7
Send EpiData-list mailing list submissions to epidata-list@lists.umanitoba.ca
To subscribe or unsubscribe via the World Wide Web, visit http://lists.umanitoba.ca/mailman/listinfo/epidata-list or, via email, send a message with subject or body 'help' to epidata-list-request@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@lists.umanitoba.ca
When replying, please edit your Subject line so it is more specific than "Re: Contents of EpiData-list digest..."
EpiData-list mailing list ___________________________________
Today's Topics:
- (no subject) (epidata-list@lists.umanitoba.ca)
- Re: (no subject) (epidata-list@lists.umanitoba.ca)
- Re: first observation among several for each person (no subject) (epidata-list@lists.umanitoba.ca)
- Re: (no subject) (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Mon, 29 Sep 2014 15:41:17 +0300 From: epidata-list@lists.umanitoba.ca Subject: [EpiData-list] (no subject) To: epidata-list@lists.umanitoba.ca Message-ID: <CAMLtmTBnDMV9Lrnq2UxM5t9H4Nd9B41aHJULbr1Y5qDL= 3NY5Q@mail.gmail.com> Content-Type: text/plain; charset=UTF-8
Dear ALL,
I have a data set where some patients have more than one entry (visit) i.e. same patient with different visit dates, while some have only one entry (visit). I would like to select only the first visit from each patient (The variables to use are id_unique and visit_date)
Regards
Walter
Message: 2 Date: Mon, 29 Sep 2014 15:56:52 +0200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] (no subject) To: epidata-list@lists.umanitoba.ca Message-ID: < CAHDXojvVqiyuSKVToxE4q82DFva6Bv6+bddzpKhxqX7FNbmV1w@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1
Hi. I cannot give you the comand syntax in epidata (maybe in Stata) but what you could simply do is the following: Create a variable first_visit_date = min(visit_date) by (id_unique) select where visit_date = firs_visit_date.
Serge
2014-09-29 14:41 GMT+02:00 epidata-list@lists.umanitoba.ca:
Dear ALL,
I have a data set where some patients have more than one entry (visit)
i.e.
same patient with different visit dates, while some have only one entry (visit). I would like to select only the first visit from each patient (The variables to use are id_unique and visit_date)
Regards
Walter _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
-- *M. Aymar Serge SOMDA, BEng. MMath. MSPH.* *M?thodologiste - Biostatisticien*
Chef Unit? de Formation et d'Appui M?thodologique Centre MURAZ Bur: (226) 20 97 01 02 Poste 438 GSM: (226) 70 44 33 22 Bobo Dioulasso, Burkina Faso Email: serge.somda@centre-muraz.bf http://www.centre-muraz.bf/
Cellule de Biostatistique Institut Universitaire du Cancer Toulouse - Oncopole Bur: (33) (0)531 155 860 GSM: (33) (0)604 521 773 Toulouse, France Email: somda.serge@iuct-oncopole.fr http://www.oncopole-toulouse.com/
Message: 3 Date: Mon, 29 Sep 2014 15:26:53 GMT From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] first observation among several for each person (no subject) To: epidata-list@lists.umanitoba.ca Message-ID: 1412004413115.66366.16794@webmail5 Content-Type: text/plain; charset=UTF-8
In analysis just do this: read "your datafile name" sort idunique visitdate gen i number = 1 if idunique = idunique[_n-1] then number = number[_n-1] + 1
- now you have a variable "number", which gives the sequence of
observations for each person.
select number = 1
- will now make sure you only analyse the first observation.
You may also use the commands aggregate, but there would be a problem (as I remember it) with dates, which are then just integers and no longer dates.
regards Jens Lauritsen EpiData Association
Den 29. sep. 2014, epidata-list@lists.umanitoba.ca skrev:
Hi. I cannot give you the comand syntax in epidata (maybe in Stata) but what you could simply do is the following: Create a variable first_visit_date = min(visit_date) by (id_unique) select where visit_date = firs_visit_date.
Serge
2014-09-29 14:41 GMT+02:00 <epidata-list@lists.umanitoba.ca>:
Dear ALL,
I have a data set where some patients have more than one entry (visit)
i.e.
same patient with different visit dates, while some have only one entry (visit). I would like to select only the first visit from each patient (The variables to use are id_unique and visit_date)
Regards
Walter _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
-- *M. Aymar Serge SOMDA, BEng. MMath. MSPH.* *M??thodologiste - Biostatisticien*
Chef Unit?? de Formation et d'Appui M??thodologique Centre MURAZ Bur: (226) 20 97 01 02 Poste 438 GSM: (226) 70 44 33 22 Bobo Dioulasso, Burkina Faso Email: serge.somda@centre-muraz.bf http://www.centre-muraz.bf/
Cellule de Biostatistique Institut Universitaire du Cancer Toulouse - Oncopole Bur: (33) (0)531 155 860 GSM: (33) (0)604 521 773 Toulouse, France Email: somda.serge@iuct-oncopole.fr http://www.oncopole-toulouse.com/
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
Message: 4 Date: Mon, 29 Sep 2014 11:36:11 -0400 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] (no subject) To: EpiData List epidata-list@lists.umanitoba.ca Message-ID: BLU436-SMTP2503B22D35AA5A8742A58E3FDBA0@phx.gbl Content-Type: text/plain; charset="windows-1252"
In Epidata Analysis, do this: (I?m using id and visit - you cannot have names with underscores in classic Epidata and it is probably not a good idea in new Epidata)
define vfirst # vfirst = 1 sort id visit if id = id[recnumber-1] then vfirst = 0 select vfirst=1
id[recnumber-1] refers to the value of id in the previous record. Since the data are sorted first by id and then visit, this will leave vfirst=1 whenever id changes.
Jamie
On Sep 29, 2014, at 8:41 AM, epidata-list@lists.umanitoba.ca wrote:
Dear ALL,
I have a data set where some patients have more than one entry (visit)
i.e.
same patient with different visit dates, while some have only one entry (visit). I would like to select only the first visit from each patient (The variables to use are id_unique and visit_date)
Regards
Walter _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 130, Issue 7
EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 130, Issue 8