- EpiData-list - University of Manitoba Mailing Lists

Merging two rec files
by epidata-list＠lists.umanitoba.ca 12 Nov '14

12 Nov '14

Dear EpiData users and experts I am trying to merge two files with different number of records and fields! The first file (intake) contains 1433 records and there is 21 fields in each record. The second one contains 1301 records and and each record contains 31 fields. Each one of the 1301 record has a corresponding record in the first file (same code). I would like to merge the two files, based on the code, so that I have a third file with 1301 records and 52 fields. I tried to use the merge function in EpiData Entry, but it didn't work (the product was a file with only 47 fields instead of 52 ). I must say that some fields in the two files have the same name-can this be a reason for not merging these fields? Your help will be highly appreciated Best, MK

1 1

Status testversions of 2.0 Manager and EntryClient
by epidata-list＠lists.umanitoba.ca 05 Nov '14

05 Nov '14

The status and reported problems in the development of v2x of Manager and EntryClient is such that: a. Basically we find rather stable function with few access violations and remaining major problems b. We found reason to further change the xml structure contained in the epx file when dataforms are in a relational structure. This means that examples you have worked with in the testing of v2x might not work, when we release the next test build. c. A number of minor points have been found in various parts of the system. Mostly these were of text formulations, which had not taken the relational dataform aspect into consideration. I expect that the next test version will be moving from experimental level to pre-release level. This is an indication that we are approaching something which in the end will be applicable for true data entry and documentation. Further thoughts and reports of or examples of malfunction are highly appreciated. Jens Lauritsen EpiData Association, Denmark

1 0

Re: EpiData-list Digest, Vol 132, Issue 1
by epidata-list＠lists.umanitoba.ca 03 Nov '14

03 Nov '14

1 0

Epola Contact tracing and risk assessment system
by epidata-list＠lists.umanitoba.ca 02 Nov '14

02 Nov '14

Hello List, As a District Medical Officer, I will have to prepare for Contact tracing and risk assessment/managing the follow-up of contacts if an unsuspected Ebola case should surface in my community. I have started to think of a call center / health care registration system in EpiData Manager with relate feature: One event/Index case, several contacts with contact details, and follow-up details of contacts. In the event that one of the contacts should develop symptoms, then the secondary case´s contacts will have to be traced. The design of the system certainly needs some consideration. This is a global concern, and I imagine several organizations probably already have made or have plans to develop such a system. EpiData´s share-friendly approach should be ideal under current circumstance. ECDC have already done so for food/waterborne outbreak investigation. 1. Anybody already made a system, wiling to share? 2. Any major Organization seeing the benefit of same-format reporting, and willing to support development of system/templates? 3. I assume that final release of ED 2.0 with relate feature is imminent. I therefore start to work on a functional but simple local system anyway, and will seek advice from the list as needed. Where I am right now, I struggle to carry the content of more than one unique key variable over from the parent to the child record. Any comments? Best regards, Vegard Hoegli District Medical Officer Skien, Norway

1 2

Adding value labels in EpiData Manager 2.0.0.1 RC2 24. Oct
by epidata-list＠lists.umanitoba.ca 28 Oct '14

28 Oct '14

Hello, I am experimenting with the new release candidae, and I´m trying to design a simple registration form in EpiData Manager. I have a couple problems that may be trivial, but nevertheless, I´m a bit stuck: 1: In the Win 64 bit version I struggle to edit Value labels for an integer field. I click "New" in the Valuelabel button and bring up the Value label editor, but I am not able to add any labels. I can, However add new values, but seen not to be able to get the label line to get focus. Tried with Enter, Tab, arrow keys, Mouse click etc but nothing works. When I Open the same file in Mac, However, There are no problems at all creating and editing a set of Value labels. I notice that i first choose between "Internal" and "external" values - a choice which didm´t appear in the Windows version. 2: Is there a way to edit the sequence the various variables get focus? After a bit of editing, the flow of focus has become mixed up. 3. Is If-then calculations implemented? I experiment with making a registration form for a call-center. First i define a variable "Caller´s name" Then a boolean variable: Do you call us on behalf of yourself? Then a variable with the name of the patient. If the call is about the caller herself, I would like to copy the content from "caller´s name" to "patient´s name" and then skip the patient name field. I realize that this not strictly necessary, but just for the experiment´s sake.. Regards, Vegard Hoegli, Skien, Norway

1 3

SV: [EpiData-list] Adding value labels in EpiData Manager 2.0.0.1 RC2 24. Oct
by epidata-list＠lists.umanitoba.ca 28 Oct '14

28 Oct '14

Such reports are very valuable. Since we upload minor adaptations quite frequently please also include build, which you get from version info in the help menu. Regards Jens Lauritsen EpiData Association epidata-list(a)lists.umanitoba.ca skrev: >Hello, >I am experimenting with the new release candidae, and I´m trying to design >a simple registration form in EpiData Manager. > >I have a couple problems that may be trivial, but nevertheless, I´m a bit >stuck: > >1: In the Win 64 bit version I struggle to edit Value labels for an integer >field. I click "New" in the Valuelabel button and bring up the Value label >editor, but I am not able to add any labels. I can, However add new values, >but seen not to be able to get the label line to get focus. Tried with >Enter, Tab, arrow keys, Mouse click etc but nothing works. > >When I Open the same file in Mac, However, There are no problems at all >creating and editing a set of Value labels. I notice that i first choose >between "Internal" and "external" values - a choice which didm´t appear in >the Windows version. > >2: Is there a way to edit the sequence the various variables get focus? >After a bit of editing, the flow of focus has become mixed up. > >3. Is If-then calculations implemented? I experiment with making a >registration form for a call-center. First i define a variable "Caller´s >name" Then a boolean variable: Do you call us on behalf of yourself? Then a >variable with the name of the patient. If the call is about the caller >herself, I would like to copy the content from "caller´s name" to >"patient´s name" and then skip the patient name field. I realize that this >not strictly necessary, but just for the experiment´s sake.. > > >Regards, > >Vegard Hoegli, >Skien, Norway >_______________________________________________ >EpiData-list mailing list >EpiData-list(a)lists.umanitoba.ca >http://lists.umanitoba.ca/mailman/listinfo/epidata-list

1 0

Updated experimental test version of relational datasets (Manager and EntryClient 2.0.0.0)
by epidata-list＠lists.umanitoba.ca 24 Oct '14

24 Oct '14

On Oct. 9th. we announced release of an experimental test version capable of creating relational structures. See: http://lists.umanitoba.ca/pipermail/epidata-list/2014q4/002546.html The following major bugs have been fixed and new versions are available: Updated versions are placed for download on http://www.epidata.dk/testing.php Manager: 1. Reports were not saved correctly as txt or html 2. Value labels could not be edited 3. Export had malfunction EntryClient: Would not propagate correctly the key from one level to the next in some instances. Please test and verify function in as well simple and complex situations. Please notice that version is still - in this upload - 2.0.0.0, but creation date is Oct 22nd., It is a good idea to use a particular ini file and recent file saving, when you are testing. To do this you add parameters/options to the start. To see the options you can run from a terminal, epidatamanager -h entryclient -h which will give the explanation, e.g. for configurations files: -i=mytest.cfg recent file list: -r=testfiles.txt regards Torsten Bonde Christiansen and Jens Lauritsen EpiData Association To verify correct version: "Copy version Info" found in the help menu and check: Manager: Program version: 2.0.0.0[RC2] r1010 EntryClient: Program version: 2.0.0.0[RC2] r411 Both of them: Core version: 2.0.0.0 r1080

1 2

Condensing several Y/N results into one table
by epidata-list＠lists.umanitoba.ca 10 Oct '14

10 Oct '14

Dear list, I try to condense the frequency of several yes/no variables into one table: In a patient file I register 12 specific procedures, where each patient get a variable number of "yes" i.e. Intravenous antibiotics N % Y 126 27.8 . 328 72.2 Total 454 100.0 Pain relief N % Y 113 24.9 . 341 75.1 Total 454 100.0 etc I want to transform the result into: Treatment summary N % Intravenous antibiotics 126 27.8 Pain relief 113 24.9 etc Total 454 100.0 In the old Epi Info v6 this was relatively simple via the REPORT command, where a template .RPT file could pick specific values from tablecells across several variables. I can copy and paste values from individual tables into a spreadsheet, but it would obviosly be more user-friendly to a routine user to be able to present the result in EpiData.directly. Any suggestions? Best regards, Vegard Hogli CMO, Skien, Norway

1 1

New test release of Manager and EntryClient (v2....)
by epidata-list＠lists.umanitoba.ca 10 Oct '14

10 Oct '14

Dear all Following a remarkable effort in many areas it is now possible to download experimental versions 2 of Epidata Manager and EntryClient from the page: http://epidata.dk/testing.php#alpha The overall new aspect is: relational databases This is also explained in the introduction document, which you find here: http://epidata.dk/php/downloadc.php?file=epidatamanagerintro.pdf We have worked a bit to further secure immediate transparency of function. In practice it seems that users are NOT reading manuals, so intuitive function is important, Suggestions to enhance intuitive function are welcomed. For projects with only one single dataform the main change will be new icons and hopefully more stability, since we have removed a number of bugs. Another new aspect is that study information is placed at the front. This is to enhance datadocumentation levels in projects. It is NOT necessary to complete the study information to define data. So if you are not interested in that part just skip it. When you create a new project an instruction is given on screen with a sequence for developing relational data. Be aware that these versions are still in the early testing phase. Which means that you should NOT use them for ongoing projects, and also that you should use them with new projects only. If you have generated relational databases with a previous testversion, then do not continue on that project. What we need - optimally during the coming week - is feedback on: - function, - access violations, - stability in EntryClient - stability in documentation - whether EntryClient creates correct datacontent based on the tree structure of relational databases. It is a rather complex system now, so please be patient and report, such that we can get to a stable level of function soon. We will summarise reports in about 10 days following a well deserved break in development. Following clarification of these issues we will release another test build, and once all problems are solved or fixed in a stable way the first public v2.0 will be released. If you have longer test files and explanations that you wish to send us and not to the list, then use info at epidata.dk for such mails - disregard the warning sent to you, we will read it. regards Jens Lauritsen Epidata Association

1 1

Re: EpiData-list Digest, Vol 130, Issue 8
by epidata-list＠lists.umanitoba.ca 01 Oct '14

01 Oct '14

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(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 130, Issue 7 - count number of > records (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 29 Sep 2014 17:26:21 +0000 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] RE: EpiData-list Digest, Vol 130, Issue 7 - > count number of records > To: "'epidata-list(a)lists.umanitoba.ca'" > <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <FE3BD206B1C952409F1892C47023A625AF98A1(a)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(a)lists.umanitoba.ca [mailto: > epidata-list-bounces(a)lists.umanitoba.ca] On Behalf Of > epidata-list-request(a)lists.umanitoba.ca > Sent: Monday, September 29, 2014 1:01 PM > To: epidata-list(a)lists.umanitoba.ca > Subject: EpiData-list Digest, Vol 130, Issue 7 > > 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. (no subject) (epidata-list(a)lists.umanitoba.ca) > 2. Re: (no subject) (epidata-list(a)lists.umanitoba.ca) > 3. Re: first observation among several for each person (no > subject) (epidata-list(a)lists.umanitoba.ca) > 4. Re: (no subject) (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 29 Sep 2014 15:41:17 +0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] (no subject) > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <CAMLtmTBnDMV9Lrnq2UxM5t9H4Nd9B41aHJULbr1Y5qDL= > 3NY5Q(a)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(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] (no subject) > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > < > CAHDXojvVqiyuSKVToxE4q82DFva6Bv6+bddzpKhxqX7FNbmV1w(a)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(a)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(a)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(a)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(a)iuct-oncopole.fr > http://www.oncopole-toulouse.com/ > > * > * > > > ------------------------------ > > Message: 3 > Date: Mon, 29 Sep 2014 15:26:53 GMT > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] first observation among several for each > person (no subject) > To: <epidata-list(a)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(a)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(a)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(a)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(a)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(a)iuct-oncopole.fr> > > <http://www.oncopole-toulouse.com/> > > > > * > > * > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)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(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] (no subject) > To: EpiData List <epidata-list(a)lists.umanitoba.ca> > Message-ID: <BLU436-SMTP2503B22D35AA5A8742A58E3FDBA0(a)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(a)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(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 130, Issue 7 > ******************************************** > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 130, Issue 8 > ******************************************** >

1 0