- EpiData-list - University of Manitoba Mailing Lists

Standard tables layout
by epidata-list＠lists.umanitoba.ca 10 Jul '07

10 Jul '07

Dear all, I have a general question regarding the layout for the output of the TABLES command. In version 2 (112) the default option for TABLES is sorted in ascending order. That means that when using boolean fields TABLES will display N,N in the top left cell of a 2 x 2 table, because internally NO=0 and Yes=1. (Jens, is that correct?) When asking for RR (TABLES VAR1 VAR2 /RR) what we get is the RR of being N in the outcome if you are N in the exposure. Which is clearly the inverse of what we usually are looking for. But because most of the statistical/epidemiological software dispay the table in the other way (Y,Y on the top left cell) EpiData can misslead the users with its results. (obviously users should read the table, but...). And we have /SD as option to change that My question is: Should EPiData follow the general rule of displaying YY in the too left cell?. (and therefore calculating the RR that usually we are interested in) Jens has a point saying that if we change that when we are not interested in RR but only in the numbers and %, most of the program follow the rule of sorting the values in ascending order and that if we want to follow this rule we will need an EPITABLE command (in version 2 he is trying to get ride of innecesary commands). I think we alreday have the EPITABLE command, it is TABLES V1 V2 /RR I would appreciate if can comment on that. Version 2 is almost ready, but i think this is an important issue. Hope my explantion and question is clear. Thanks a lot, Pedro Arias EpiData Spanish cotranslator

1 2

Longitudinal data validity checks
by epidata-list＠lists.umanitoba.ca 09 Jul '07

09 Jul '07

One very efficient approach for overview of consistency. E.g. counts of id numbers at various times is to use the "count by id" function in document menu of EpiData Entry. (or for batch procedures with EpiC). The idea is to count in different files how many times a unique identifier was found:. Example output: Count of records based on field ID Selected files: File 1 = key.rec File 2 = data\idkey.rec 120 different values for ID found Files ID 1 2 --------------------- 0 1 1 1 6 6 2 6 6 The key variable could as here be a simple integer, but could also be a string, e.g. of the type: 0-1 0-2 0-3 constructed as a combination of the id (here 0) and the time of visit (here either 1 2 or 3). In the check file: id mustenter end timevar comment legal 1 "Initial visit" 2 "6 months follow-up" 3 "2 year follow up" end mustenter after entry idkey = string(id) + "-" + string(timevar) end end idkey key unique noenter end ......................................... Notice that the "key unique" status for idkey is checked at creation of the contents, that is in the "after entry" block of the time variable. regards Jens Lauritsen EpiData Association

1 0

consistency checks on longitudinal data
by epidata-list＠lists.umanitoba.ca 09 Jul '07

09 Jul '07

Hello all, I'm setting up a multi-centre longitudinal study where data will be entered by health care workers with very little experience of research or possibly of computers. Every two weeks they will be visited by researchers. The data will be entered long, ie with one record for each time point. I need the data entry to be very simple, and the researchers will run consistency checks to find problems. Some things I want to do are: 1) check for duplicates on a few fields ( of course there is a unique ID - this would be to pick up duplicate data with different IDs) 2) check number of time points per patient ID 3) check dates are within range 4) check that date for time point 2 comes after date for time point 1 for the same patient ID I have used EpiData for entry for a few years but I haven't used Analysis. I would be glad of any advice. Thanks, Vicky Simms -- Vicky Simms Research Associate Palliative Care, Policy and Rehabilitation King's College London

1 1

Changing color of a field: Re: EpiData-list Digest, Vol 44, Issue 7
by epidata-list＠lists.umanitoba.ca 29 Jun '07

29 Jun '07

Hi, i'm a new user of epidata, but already familiar with epi6. This is my first time replying to an inquiry, and hope to provide some tips or at least initiate an idea to solving an inquiry. To change the color of a field, a noenter or otherwise, you can have it defined at the beginning of a check file using the BEFORE FILE command, specifying the name of a field, and the color you want: BEFORE FILE COLOR vname color (i'm out in a field right now, i do not have access to my own pc, just using an internet cafe pc without epidata, so i can not provide more details on the command.) Thanks. . . knowell On 6/21/07, epidata-list-request(a)lists.umanitoba.ca < 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. Alyshia Landry is out of the office. > (epidata-list(a)lists.umanitoba.ca) > 2. nonter field (epidata-list(a)lists.umanitoba.ca) > 3. noenter field (epidata-list(a)lists.umanitoba.ca) > 4. Re: nonter field (epidata-list(a)lists.umanitoba.ca) > 5. RE: nonter field (epidata-list(a)lists.umanitoba.ca) > 6. Jumps in Epidata Entry (epidata-list(a)lists.umanitoba.ca) > 7. Re: Jumps in Epidata Entry (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 19 Jun 2007 13:25:33 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Alyshia Landry is out of the office. > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > < > OF5CCB8794.BB7D23E5-ON852572FF.005FB91E-852572FF.005FB91E(a)region.waterloo.on.ca > > > > Content-Type: text/plain; charset=US-ASCII > > > I will be out of the office starting 06/19/2007 and will not return until > 06/21/2007. > > If you require immediate assistance, please contact Stephen Drew at > extension 5330. > > > > > ------------------------------ > > Message: 2 > Date: Tue, 19 Jun 2007 21:25:21 -0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] nonter field > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <467873F1.5010202(a)ufba.br> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi epidata users ! > > Please, how can I change the color of a noenter field ? I tried modify > it using the colour function into a before block, but it works for every > field except the noenter field. > > I also tried to change the epidata.ini file, but it doesn´t work anyway. > > Where is my mistake ? > > I´d like to change the grey colour to another stronger one. > > Thank you very much. > > Mauricio > > > > ------------------------------ > > Message: 3 > Date: Tue, 19 Jun 2007 21:26:35 -0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] noenter field > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4678743B.5050004(a)ufba.br> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi epidata users ! > > Please, how can I change the color of a noenter field ? I tried modify > it using the colour function into a before block, but it works for every > field except the noenter field. > > I also tried to change the epidata.ini file, but it doesn´t work anyway. > > Where is my mistake ? > > I´d like to change the grey colour to another stronger one. > > Thank you very much. > > Mauricio > > > > ------------------------------ > > Message: 4 > Date: Tue, 19 Jun 2007 19:34:40 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] nonter field > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <46786810.3080009(a)sympatico.ca> > Content-Type: text/plain; charset="ISO-8859-1" > > > > ------------------------------ > > Message: 5 > Date: Wed, 20 Jun 2007 09:35:05 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: RE: [EpiData-list] nonter field > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <A7EAEBFDDEDEF440A7BDD772C73046A20B724769(a)xch-vac.ivs.local> > Content-Type: text/plain; charset="iso-8859-1" > > Hi Mauricio; > The noenter function hides the field, so it is nor reachable. So, I doubt > there is a way to modify its color. > Gilles Delmas > > -----Message d'origine----- > De : epidata-list(a)lists.umanitoba.ca [mailto: > epidata-list(a)lists.umanitoba.ca] > Envoyé : mardi 19 juin 2007 11:40 > À : epidata-list(a)lists.umanitoba.ca > Objet : [EpiData-list] nonter field > > Hi epidata users ! > > Please, how can I change the color of a noenter field ? I tried modify it > using the colour function into a before block, but it works for every field > except the noenter field. > > I also tried to change the epidata.ini file, but it doesn´t work anyway. > > Where is my mistake ? > > I´d like to change the grey colour to another stronger one. > > Thank you very much. > > Mauricio > > > > ------------------------------ > > Message: 6 > Date: Wed, 20 Jun 2007 10:34:14 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Jumps in Epidata Entry > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <6.1.2.0.0.20070620101610.01d0bec0(a)pop.socsci.ru.nl> > Content-Type: text/plain; charset="us-ascii"; format=flowed > > Dear list, > > I have two questions regarding Jumps in EpiData Entry. > > 1) I want to jump to variable v10 if de score for v8 is 1 to 7. Of course > this works: > v8 > RANGE 1 9 > COMMENT LEGAL USE oplcat > JUMPS > 1 v10 > 2 v10 > 3 v10 > 4 v10 > 5 v10 > 6 v10 > 7 v10 > END > MUSTENTER > END > > Is a shorter syntax possible and if so, how? > > > 2) Is it possible to make a jump defination that depends on the value > entered in a previous question? > For example: > After entering the value for variable v5 I want to jump to v8 if the > answer > on question v3=1. > > Kind Regards, > Pieter van Groenestijn > The Netherlands > > > > > > > ------------------------------ > > Message: 7 > Date: Wed, 20 Jun 2007 09:01:10 +0000 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Jumps in Epidata Entry > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4678ECD6.1040708(a)ird.bf> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi Pieter, > > You can use a "IF... THEN..." syntax instead of "JUMP". > > > For your examples: > > V8 > AFTER ENTRY > IF (V8 > 0 AND V8 < 8) THEN GOTO V10 > END > END > > > V5 > AFTER ENTRY > IF V3 = 1 THEN GOTO V8 > END > END > > > As you can see, this is pretty easy! > > Regards > > Yves > ------------------------------------------------------- > Yves MARTIN-PREVEL, Epidemiologist, MD, MSc, PhD > Nutrition Unit (WHO Collaborating Center for Nutrition) > Institut de Recherche pour le Développement (IRD) > 01 BP 182 - OUAGADOUGOU 01 - BURKINA FASO > Tel: +226 50 30 67 37; Fax: +226 50 31 03 85 > http://www.ird.bf/ > > epidata-list(a)lists.umanitoba.ca a écrit : > > Dear list, > > > > I have two questions regarding Jumps in EpiData Entry. > > > > 1) I want to jump to variable v10 if de score for v8 is 1 to 7. Of > > course this works: > > v8 > > RANGE 1 9 > > COMMENT LEGAL USE oplcat > > JUMPS > > 1 v10 > > 2 v10 > > 3 v10 > > 4 v10 > > 5 v10 > > 6 v10 > > 7 v10 > > END > > MUSTENTER > > END > > > > Is a shorter syntax possible and if so, how? > > > > > > 2) Is it possible to make a jump defination that depends on the value > > entered in a previous question? > > For example: > > After entering the value for variable v5 I want to jump to v8 if the > > answer on question v3=1. > > > > Kind Regards, > > Pieter van Groenestijn > > The Netherlands > > > > > > > > > > _______________________________________________ > > 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 44, Issue 7 > ******************************************* > -- Knowell

1 1

Chris Sellers/FHS/ADPH is out of the office.
by epidata-list＠lists.umanitoba.ca 27 Jun '07

27 Jun '07

I will be out of the office starting Fri 06/22/2007 and will not return until Mon 07/02/2007. I will check emails periodically while I am away. If an issue needs immediate attention, please, contact Fred Grady at FredGrady(a)adph.state.al.us. Otherwise, I will respond to your email when I return.

1 0

Jumps in Epidata Entry
by epidata-list＠lists.umanitoba.ca 20 Jun '07

20 Jun '07

Dear list, I have two questions regarding Jumps in EpiData Entry. 1) I want to jump to variable v10 if de score for v8 is 1 to 7. Of course this works: v8 RANGE 1 9 COMMENT LEGAL USE oplcat JUMPS 1 v10 2 v10 3 v10 4 v10 5 v10 6 v10 7 v10 END MUSTENTER END Is a shorter syntax possible and if so, how? 2) Is it possible to make a jump defination that depends on the value entered in a previous question? For example: After entering the value for variable v5 I want to jump to v8 if the answer on question v3=1. Kind Regards, Pieter van Groenestijn The Netherlands

1 2

nonter field
by epidata-list＠lists.umanitoba.ca 20 Jun '07

20 Jun '07

Hi epidata users ! Please, how can I change the color of a noenter field ? I tried modify it using the colour function into a before block, but it works for every field except the noenter field. I also tried to change the epidata.ini file, but it doesn´t work anyway. Where is my mistake ? I´d like to change the grey colour to another stronger one. Thank you very much. Mauricio

1 2

noenter field
by epidata-list＠lists.umanitoba.ca 19 Jun '07

19 Jun '07

Hi epidata users ! Please, how can I change the color of a noenter field ? I tried modify it using the colour function into a before block, but it works for every field except the noenter field. I also tried to change the epidata.ini file, but it doesn´t work anyway. Where is my mistake ? I´d like to change the grey colour to another stronger one. Thank you very much. Mauricio

1 0

nonter field
by epidata-list＠lists.umanitoba.ca 19 Jun '07

19 Jun '07

Hi epidata users ! Please, how can I change the color of a noenter field ? I tried modify it using the colour function into a before block, but it works for every field except the noenter field. I also tried to change the epidata.ini file, but it doesn´t work anyway. Where is my mistake ? I´d like to change the grey colour to another stronger one. Thank you very much. Mauricio

1 0

Alyshia Landry is out of the office.
by epidata-list＠lists.umanitoba.ca 19 Jun '07

19 Jun '07

I will be out of the office starting 06/19/2007 and will not return until 06/21/2007. If you require immediate assistance, please contact Stephen Drew at extension 5330.

1 0