- EpiData-list - University of Manitoba Mailing Lists

Re: EpiData-list Digest, Vol 103, Issue 7
by epidata-list＠lists.umanitoba.ca 27 May '12

27 May '12

Hi Hans This also doesn't work. I also exported the file, 1065 records, into excel and when I tried to copy and import it into epidata analysis immediately, the software shut down immediately. It only works with 50 records. Thanks Mohammed On Fri, May 25, 2012 at 7:00 PM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > Send EpiData-list mailing list submissions to > epidata-list(a)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(a)lists.umanitoba.ca > > You can reach the person managing the list at > epidata-list-owner(a)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: > > 1. Re: Re: EpiData-list Digest, Vol 103, Issue 5 > (epidata-list(a)lists.umanitoba.ca) > 2. Re: Re: EpiData-list Digest, Vol 103, Issue 5 > (epidata-list(a)lists.umanitoba.ca) > 3. Re: Relational databse (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 24 May 2012 20:12:06 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Re: EpiData-list Digest, Vol 103, Issue 5 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4FBE79F6.3050508(a)tbrieder.org> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Mohd: > > Have you tried to start everything again from scratch, ie, doing a > reinstall of EpiData Analysis? I know, last-resort proposal, but it > doesn't seem that anything else anybody proposes is fixing it, thus > let's hope it is just some corrupt file. > > Hans > > > On 23-May-12 19:08, epidata-list(a)lists.umanitoba.ca wrote: > > Hi Rod > > There are no deleted records > > > > Thanks > > Mohd > > -- > Hans L Rieder, MD, MPH > Jetzikofenstr 12 > 3038 Kirchlindach > Switzerland > > Tel: +41 31 829 4577 > Mob: +41 79 321 9122 > Web: http://www.tbrieder.org > > > > > ------------------------------ > > Message: 2 > Date: Thu, 24 May 2012 14:31:42 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Re: EpiData-list Digest, Vol 103, Issue 5 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <BLU0-SMTP623D25377A2C85B343B300FD000(a)phx.gbl> > Content-Type: text/plain; charset="us-ascii" > > It is worth having a look at the file in an editor. If you are not going > to save it again, even Word will do, but change the font to Courier. > You should see the header information all lined up and then the data all > lined up with maximum 80 characters per line. It is pretty easy to see if > the file is corrupted (e.g. it got only partially copied from somewhere or > was edited with something like Word. > > I do this all the time if I have a problem with a data file and the > problem has always been one of the following: > > 1. The data came from EpiInfo - EpiInfo forgives a lot of errors in data > sets and won't tell you about them > 2. There is garbage part of the way through the file - indicates a disk > error or that the computer was shut off before the file was completely saved > 3. There is an extra blank line at the end or the very last line is not > complete or has extra spaces at the end > > Of course, if any of those are true, Epidata Entry won't read the file > either. > > The other potential problem is a corrupt .chk file, although there is a > pretty clear error message about that in my experience. > > Good luck... > > (by the way, a few of us are quite able to diagnose a .rec file problem, > but that means sending your data to a stranger) > > Jamie > > On 2012-05-24, Hans wrote: > > > Mohd: > > > > Have you tried to start everything again from scratch, ie, doing a > reinstall of EpiData Analysis? I know, last-resort proposal, but it doesn't > seem that anything else anybody proposes is fixing it, thus let's hope it > is just some corrupt file. > > > > Hans > > > > > > ------------------------------ > > Message: 3 > Date: Fri, 25 May 2012 12:56:45 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Relational databse > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4FBF656D.5010201(a)epidata.dk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 05/23/2012 07:22 AM, epidata-list(a)lists.umanitoba.ca wrote: > > Which command should I use so that when the "child" record opens, it > > automatically opens a new blank record (child). > > > > Walter > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > Depends on your definition of relate. But Ctrl+N should make a new record. > > If your relate is a 1-1 there can be only one record in the child file > per id. > > regards > Jens Lauritsen > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 103, Issue 7 > ******************************************** > -- * --------------------------------------------------------- I have held many things in my hands, and have lost them all, But whatever I have placed in God's hands, that I still possess. *

1 1

iPad, Android
by epidata-list＠lists.umanitoba.ca 25 May '12

25 May '12

Dear all, I just changed from the legacy Epidata to Epidata manager. It took a while to get used to the new philosophy, but I find it more easy to use compared to the legacy version. And I see clearly more development in this aspect. My question is whether you will develop iPad or Android versions of the programme. Initially it should be for the Epidata Client only, since by using tablet computers you could remove the need for purely data-entry staff. Regards from Kabul, Aiso Vos

1 0

Help with export using Epidata Project
by epidata-list＠lists.umanitoba.ca 25 May '12

25 May '12

Good day! I'm totally new to Epidata and would like to ask help on exporting data entered using v1.1. When I explored Epidata Manager, there is an exporting option but only stata. Our requirement is to export to notepad. I've been searching all over for answers but I'm really having a hard time to know how this may be done using v1.1. Thanks in advance. Regards, Paulo

1 0

Relational databse
by epidata-list＠lists.umanitoba.ca 25 May '12

25 May '12

Which command should I use so that when the "child" record opens, it automatically opens a new blank record (child). Walter

1 1

Re: EpiData-list Digest, Vol 103, Issue 5
by epidata-list＠lists.umanitoba.ca 24 May '12

24 May '12

Hi Rod There are no deleted records Thanks Mohd On Wed, May 23, 2012 at 7:00 PM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > Send EpiData-list mailing list submissions to > epidata-list(a)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(a)lists.umanitoba.ca > > You can reach the person managing the list at > epidata-list-owner(a)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: > > 1. Re: EpiData-list Digest, Vol 103, Issue 4 > (epidata-list(a)lists.umanitoba.ca) > 2. RE: Epidata analysis not reading my rec file > (epidata-list(a)lists.umanitoba.ca) > 3. Relational databse (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 22 May 2012 19:09:07 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Re: EpiData-list Digest, Vol 103, Issue 4 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <CAEJOQjf6iKqup_u5qMyxwDgqai9+JiaKNaK3fyN6N0a+i5aErg(a)mail.gmail.com > > > Content-Type: text/plain; charset=windows-1252 > > Hi Jens > > I can only see the green light at the bottom status line but with no number > of records. > > It can pereectly be opened by epidata entry. > > Regards > Mohammed > > On Tue, May 22, 2012 at 7:00 PM, <epidata-list-request(a)lists.umanitoba.ca > >wrote: > > > Send EpiData-list mailing list submissions to > > epidata-list(a)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(a)lists.umanitoba.ca > > > > You can reach the person managing the list at > > epidata-list-owner(a)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: > > > > 1. Epidata analysis not reading my rec file > > (epidata-list(a)lists.umanitoba.ca) > > 2. Re: Epidata analysis not reading my rec file > > (epidata-list(a)lists.umanitoba.ca) > > 3. Re: Epidata analysis not reading my rec file > > (epidata-list(a)lists.umanitoba.ca) > > 4. Re: Epidata analysis not reading my rec file > > (epidata-list(a)lists.umanitoba.ca) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 21 May 2012 22:41:44 +0200 > > From: epidata-list(a)lists.umanitoba.ca > > Subject: [EpiData-list] Epidata analysis not reading my rec file > > To: epidata-list(a)lists.umanitoba.ca > > Message-ID: > > < > CAEJOQjfdEJvrorGGrsbJnrWpehgjgiEmMyMsgca_aBv_xFG9DQ(a)mail.gmail.com > > > > > Content-Type: text/plain; charset=ISO-8859-1 > > > > Hello > > > > Would someone tell me please what might be the problem when epidata > > analysis doesn't read rec file. > > > > Thanks > > Mohd > > > > -- > > * > > --------------------------------------------------------- > > I have held many things in my hands, and have lost them all, But > whatever I > > have placed in God's hands, that I still possess. > > * > > > > > > ------------------------------ > > > > Message: 2 > > Date: Mon, 21 May 2012 23:30:08 +0200 > > From: epidata-list(a)lists.umanitoba.ca > > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > > To: epidata-list(a)lists.umanitoba.ca > > Message-ID: <4FBAB3E0.2040609(a)epidata.dk> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > > > On 05/21/2012 10:41 PM, epidata-list(a)lists.umanitoba.ca wrote: > > > Hello > > > > > > Would someone tell me please what might be the problem when epidata > > > analysis doesn't read rec file. > > > > > > Thanks > > > Mohd > > > > > > > Try setting: > > > > set echo=on > > > > maybe your file was read, but the message was not showing. > > If the file was read you can also see the number of records at the > > bottom status line > > > > regards > > > > Jens Lauritsen > > > > > > ------------------------------ > > > > Message: 3 > > Date: Mon, 21 May 2012 18:25:02 -0300 > > From: epidata-list(a)lists.umanitoba.ca > > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > > To: epidata-list(a)lists.umanitoba.ca > > Message-ID: <4FBAB2AE.9070001(a)infomedica.com.br> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > > > It might be corrupted in someway. > > Did you manipulate it with any other program besides EpiData programs? > > Try to open it with EpiData Entry. > > > > Marco Moura > > > > Em 21/05/2012 17:41, epidata-list(a)lists.umanitoba.ca escreveu: > > > Hello > > > > > > Would someone tell me please what might be the problem when epidata > > > analysis doesn't read rec file. > > > > > > Thanks > > > Mohd > > > > > > > > > -- > > ---------------------------------------------------------------- > > MARCO ANTONIO MOURA REIS, MD PhD ma > > Universidade da Região de Joinville - UNIVILLE > > Maternidade Darcy Vargas > > Joinville (SC) - Brazil > > ---------------------------------------------------------------- > > > > > > ------------------------------ > > > > Message: 4 > > Date: Tue, 22 May 2012 19:14:35 +0300 (EAT) > > From: epidata-list(a)lists.umanitoba.ca > > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > > To: epidata-list(a)lists.umanitoba.ca > > Message-ID: <cd62dc0b-cc39-4e39-ad12-1d7ae226cc5e(a)z04.dts.mg> > > Content-Type: text/plain; charset=utf-8 > > > > I think that Marco is right : the file might be corrupted. If Epidata > > Entry cannot open it, try to open and fix the file with Epi6 (EpiInfo for > > DOS system: you can download it from CDC website). I had the same problem > > and I could fix the file using this way. > > > > Dr Andriamahenina > > > > ----- Mail original ----- > > > > De: epidata-list(a)lists.umanitoba.ca > > Ã€: epidata-list(a)lists.umanitoba.ca > > EnvoyÃ©: Mardi 22 Mai 2012 00:25:02 > > Objet: Re: [EpiData-list] Epidata analysis not reading my rec file > > > > It might be corrupted in someway. > > Did you manipulate it with any other program besides EpiData programs? > > Try to open it with EpiData Entry. > > > > Marco Moura > > > > Em 21/05/2012 17:41, epidata-list(a)lists.umanitoba.ca escreveu: > > > Hello > > > > > > Would someone tell me please what might be the problem when epidata > > > analysis doesn't read rec file. > > > > > > Thanks > > > Mohd > > > > > > > > > -- > > ---------------------------------------------------------------- > > MARCO ANTONIO MOURA REIS, MD PhD ma > > Universidade da RegiÃ£o de Joinville - UNIVILLE > > Maternidade Darcy Vargas > > Joinville (SC) - Brazil > > ---------------------------------------------------------------- > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > > > > > ------------------------------ > > > > ________________________________________ > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > > > End of EpiData-list Digest, Vol 103, Issue 4 > > ******************************************** > > > > > > -- > * > --------------------------------------------------------- > I have held many things in my hands, and have lost them all, But whatever I > have placed in God's hands, that I still possess. > * > > > ------------------------------ > > Message: 2 > Date: Tue, 22 May 2012 14:46:29 -0700 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] RE: Epidata analysis not reading my rec file > To: "'epidata-list(a)lists.umanitoba.ca'" > <epidata-list(a)lists.umanitoba.ca> > Message-ID: > < > 645D1E644E63304987164636A12B4B66022A105E5D(a)EXCM0001.fraserhealth.org> > Content-Type: text/plain; charset="us-ascii" > > Are there any records in your rec file that are marked for deletion? I > had EpiData Analysis stall on me when it tried to read a rec file with a > deleted record. I used the 'pack file' function in EpiData to get rid of > the records that were marked for deletion. After that it worked fine. > > I suppose you could also undelete these marked records, but then they will > show up in your analysis. > > Rod > > > > > > > > ------------------------------ > > Message: 3 > Date: Wed, 23 May 2012 07:22:05 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Relational databse > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <CAMLtmTBk1n3pHJ+peopcGbeVEz3n99gJJEVFUJioWVjJ_z6i-g(a)mail.gmail.com > > > Content-Type: text/plain; charset=ISO-8859-1 > > Which command should I use so that when the "child" record opens, it > automatically opens a new blank record (child). > > Walter > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 103, Issue 5 > ******************************************** > -- * --------------------------------------------------------- I have held many things in my hands, and have lost them all, But whatever I have placed in God's hands, that I still possess. *

1 2

RE: Epidata analysis not reading my rec file
by epidata-list＠lists.umanitoba.ca 22 May '12

22 May '12

Are there any records in your rec file that are marked for deletion? I had EpiData Analysis stall on me when it tried to read a rec file with a deleted record. I used the 'pack file' function in EpiData to get rid of the records that were marked for deletion. After that it worked fine. I suppose you could also undelete these marked records, but then they will show up in your analysis. Rod

1 0

Re: EpiData-list Digest, Vol 103, Issue 4
by epidata-list＠lists.umanitoba.ca 22 May '12

22 May '12

Hi Jens I can only see the green light at the bottom status line but with no number of records. It can pereectly be opened by epidata entry. Regards Mohammed On Tue, May 22, 2012 at 7:00 PM, <epidata-list-request(a)lists.umanitoba.ca>wrote: > Send EpiData-list mailing list submissions to > epidata-list(a)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(a)lists.umanitoba.ca > > You can reach the person managing the list at > epidata-list-owner(a)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: > > 1. Epidata analysis not reading my rec file > (epidata-list(a)lists.umanitoba.ca) > 2. Re: Epidata analysis not reading my rec file > (epidata-list(a)lists.umanitoba.ca) > 3. Re: Epidata analysis not reading my rec file > (epidata-list(a)lists.umanitoba.ca) > 4. Re: Epidata analysis not reading my rec file > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 21 May 2012 22:41:44 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Epidata analysis not reading my rec file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <CAEJOQjfdEJvrorGGrsbJnrWpehgjgiEmMyMsgca_aBv_xFG9DQ(a)mail.gmail.com > > > Content-Type: text/plain; charset=ISO-8859-1 > > Hello > > Would someone tell me please what might be the problem when epidata > analysis doesn't read rec file. > > Thanks > Mohd > > -- > * > --------------------------------------------------------- > I have held many things in my hands, and have lost them all, But whatever I > have placed in God's hands, that I still possess. > * > > > ------------------------------ > > Message: 2 > Date: Mon, 21 May 2012 23:30:08 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4FBAB3E0.2040609(a)epidata.dk> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 05/21/2012 10:41 PM, epidata-list(a)lists.umanitoba.ca wrote: > > Hello > > > > Would someone tell me please what might be the problem when epidata > > analysis doesn't read rec file. > > > > Thanks > > Mohd > > > > Try setting: > > set echo=on > > maybe your file was read, but the message was not showing. > If the file was read you can also see the number of records at the > bottom status line > > regards > > Jens Lauritsen > > > ------------------------------ > > Message: 3 > Date: Mon, 21 May 2012 18:25:02 -0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4FBAB2AE.9070001(a)infomedica.com.br> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > It might be corrupted in someway. > Did you manipulate it with any other program besides EpiData programs? > Try to open it with EpiData Entry. > > Marco Moura > > Em 21/05/2012 17:41, epidata-list(a)lists.umanitoba.ca escreveu: > > Hello > > > > Would someone tell me please what might be the problem when epidata > > analysis doesn't read rec file. > > > > Thanks > > Mohd > > > > > -- > ---------------------------------------------------------------- > MARCO ANTONIO MOURA REIS, MD PhD ma > Universidade da Região de Joinville - UNIVILLE > Maternidade Darcy Vargas > Joinville (SC) - Brazil > ---------------------------------------------------------------- > > > ------------------------------ > > Message: 4 > Date: Tue, 22 May 2012 19:14:35 +0300 (EAT) > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Epidata analysis not reading my rec file > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <cd62dc0b-cc39-4e39-ad12-1d7ae226cc5e(a)z04.dts.mg> > Content-Type: text/plain; charset=utf-8 > > I think that Marco is right : the file might be corrupted. If Epidata > Entry cannot open it, try to open and fix the file with Epi6 (EpiInfo for > DOS system: you can download it from CDC website). I had the same problem > and I could fix the file using this way. > > Dr Andriamahenina > > ----- Mail original ----- > > De: epidata-list(a)lists.umanitoba.ca > Ã€: epidata-list(a)lists.umanitoba.ca > EnvoyÃ©: Mardi 22 Mai 2012 00:25:02 > Objet: Re: [EpiData-list] Epidata analysis not reading my rec file > > It might be corrupted in someway. > Did you manipulate it with any other program besides EpiData programs? > Try to open it with EpiData Entry. > > Marco Moura > > Em 21/05/2012 17:41, epidata-list(a)lists.umanitoba.ca escreveu: > > Hello > > > > Would someone tell me please what might be the problem when epidata > > analysis doesn't read rec file. > > > > Thanks > > Mohd > > > > > -- > ---------------------------------------------------------------- > MARCO ANTONIO MOURA REIS, MD PhD ma > Universidade da RegiÃ£o de Joinville - UNIVILLE > Maternidade Darcy Vargas > Joinville (SC) - Brazil > ---------------------------------------------------------------- > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 103, Issue 4 > ******************************************** > -- * --------------------------------------------------------- I have held many things in my hands, and have lost them all, But whatever I have placed in God's hands, that I still possess. *

1 0

Epidata analysis not reading my rec file
by epidata-list＠lists.umanitoba.ca 22 May '12

22 May '12

Hello Would someone tell me please what might be the problem when epidata analysis doesn't read rec file. Thanks Mohd -- * --------------------------------------------------------- I have held many things in my hands, and have lost them all, But whatever I have placed in God's hands, that I still possess. *

1 3

RE: EpiData-list Digest, Vol 103, Issue 2
by epidata-list＠lists.umanitoba.ca 04 May '12

04 May '12

Thanks Hans! That was the issue. Renate -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request(a)lists.umanitoba.ca Sent: Friday, May 04, 2012 1:00 PM To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 103, Issue 2 Send EpiData-list mailing list submissions to epidata-list(a)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(a)lists.umanitoba.ca You can reach the person managing the list at epidata-list-owner(a)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: 1. Re: merging of files (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Thu, 03 May 2012 21:18:36 +0200 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] merging of files To: epidata-list(a)lists.umanitoba.ca Message-ID: <4FA2DA0C.40507(a)tbrieder.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Did you get it the right way around? If one person has 1 or more visits, then you read the visits file and add information from the person-file: read "visitsfile.rec" merge uniqueid /file="presonfile.rec" /table savedata "newfile" freq mergevar MERGEVAR is created by EpiData and takes 3 values, only in original, only in external, in both. Regards, Hans On 02-May-12 20:13, epidata-list(a)lists.umanitoba.ca wrote: > Hi there, > > > > I am in the process of merging files in EpiData Analysis. I am looking > for syntax that would allow me to keep all the records in the file not > just the records that are in common in file1 (individual information) > and file2 (visit information). File 2 contains only information of > those that are already included in File1. > > > > For example, file1 has a 100 records and file2 has 10. One person has > 5 visits and 5 others have one record. > > The merged file ideally includes all records from file1 and file2 (104 > records). I have tried several options and failed as there are > duplicate ID's. > > Example: > > > > close > > logclose > > > > read "C:\file1.rec" > > merge id /file=: \file2.rec" /table > > savedata "C:\file3.rec " /replace > > > > I am looking forward to hear how I can resolve this issue. > > > > Thanks, > > > > Renate > > > > -- Hans L Rieder, MD, MPH Jetzikofenstr 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 103, Issue 2 ********************************************

1 0

merging of files
by epidata-list＠lists.umanitoba.ca 03 May '12

03 May '12

Hi there, I am in the process of merging files in EpiData Analysis. I am looking for syntax that would allow me to keep all the records in the file not just the records that are in common in file1 (individual information) and file2 (visit information). File 2 contains only information of those that are already included in File1. For example, file1 has a 100 records and file2 has 10. One person has 5 visits and 5 others have one record. The merged file ideally includes all records from file1 and file2 (104 records). I have tried several options and failed as there are duplicate ID's. Example: close logclose read "C:\file1.rec" merge id /file="C: \file2.rec" /table savedata "C:\file3.rec " /replace I am looking forward to hear how I can resolve this issue. Thanks, Renate

1 1