- EpiData-list - University of Manitoba Mailing Lists

Changing id value
by epidata-list＠lists.umanitoba.ca 24 Nov '08

24 Nov '08

Can anyone tell me how to change the value of in my id? When ever I change the value some of my data disappears. Thanks Raphael

1 0

Numeric Range for field
by epidata-list＠lists.umanitoba.ca 24 Nov '08

24 Nov '08

Hello, In the .chk file, I want to define a range for a numeric field (v1 ###) as follows: 100-120, 200-250 (Break the continuity) But I'm trying generates an error. Note: Epidata accept: 100-120, 200 In addition tried v1 RANGE 100 120 RANGE 200 250 END Then, open the REC but when entering data and a message "is not a valid floating point value" What's happening? and how can I set the range for my values, without defining them individually? Cordially Carlos Ortega Areyte Biostatistics from Chile, South America -- Carlos A. Ortega Areyte Prof. de Matemática y Computación Magíster en Bioestadística ACADÉMICO

1 0

Select, if and count giving different numbers in EpiData Analysis v2x
by epidata-list＠lists.umanitoba.ca 21 Nov '08

21 Nov '08

For certain logical statements the following commands would work on different subsets of the data read myfile sort samlet select if (samlet = samlet[_n-1]) count if (samlet = samlet[_n-1]) test = test + "x" if (samlet = samlet[_n-1]) if (samlet = samlet[_n-1]) then test = test + "x" .................................................................................................................... The bad news is that this is very bad behaviour. The good news is that the cause of the error has been located and a new build (v2.1.0.157) has been uploaded. If you are not working with selects and if statements this will not affect your work. Strange that no-one found the bug before (I found this yesterday) and the test environment has been extended with this aspect. regards Jens Lauritsen EpiData Association

1 0

How to: repeat variables for group level entry and clear when group changes
by epidata-list＠lists.umanitoba.ca 21 Nov '08

21 Nov '08

Posed indirectly: >Can anyone help me with the following question? >Is there a function on EpiData Entry which allows data to be >repeated from one record to the other (without the data enterer >having to fill in all the same data again)? > >For example, we are interviewing all the family members in 10 >different households. On the record of each household member, the > 'household' data will be the same, but their individual data will be > different. We want the household data to appear on each record >without the data enterer having to re-enter all the data. > >Is it possible to put a command in the .chk file so the data is >re-entered on that record automatically? > >For Example: >Qu: Does this individual belong to the same household as the >previous record? (If the answer is yes, the 'household data' will > automatically replicate that of the previous record). >Thanks in advance for your advice, > > Dr Jean-Francois Trani > Leonard Cheshire Disability and Inclusive Development Centre > University College London > Website: www.lcdisability.org/idc Answer: This can be done with the "repeat" and "clear" feature. An example has been uploaded to the page http://www.epidata.dk/examples.php ................................................................................................................ Extract of chk file is: same COMMENT LEGAL USE label_same MUSTENTER type comment allfields Blue AFTER ENTRY IF same = 2 THEN CLEAR class CLEAR school ELSE GOTO age ENDIF END END school COMMENT LEGAL USE label_school REPEAT END ................................................................................................................ regards Jens Lauritsen EpiData Association

1 0

Database
by epidata-list＠lists.umanitoba.ca 19 Nov '08

19 Nov '08

Hi. Hi. Can Epidata fetch data from one or more database and add up the data in Epidata database? Is Epidata safe for using in matters of social security numbers etc.? Thanks in advance/ Uffe.

1 2

SPC commands for testing and other aspects of EpiData Analysis v2.1
by epidata-list＠lists.umanitoba.ca 16 Nov '08

16 Nov '08

Dear All We are approaching finalisation of the current SPC graph implementation in EpiData Analysis. But await comments and further testing by users and specialists. Some errors were found in build 155 for Ichart-moving range charts. Today build 156 has been uploaded. Since public release of v2.1.0 the following SPC graphs have been implemented in the test version 2.1.1. build 156 available from http://www.epidata.dk/testing.php : Gchart, UChart, XBar (Sigma and Range), CChart, Ichart moving range Apart from the new commands it would be good if users would comment further on the new aspects of v2.1, e.g. the current implementation of lifetables. How is it working in practice, is the help file sufficient etc. An issue was raised on the list regarding use of "actuarial versus Kaplan-Meier" principles. It seems as if this relates to use of floating point variables (e.g. 1.4 week) for the time variable, which now is read as a rounded integer variable. Following further clarification I will notify here. Next in line in the development is release of a translation tool, such that analysis can be translated in a "smooth" way. And in analysis further implementation of "set ...." will be added to facilitate easier default setting of user options. The following general "set" will be added: set graph option=" ......" (for all graphs) set table option=" ......" (for cross tables and frequency tables) set spc option=" ..... " (for spc graphs and analysis) Possible also the following will be added for means, describe etc.: set descriptive option="..... " regards Jens Lauritsen EpiData Association

1 0

Date-illegal entry
by epidata-list＠lists.umanitoba.ca 14 Nov '08

14 Nov '08

Thank you for your response to my date question. During entry, if the date field is not applicable to a certain record (whereas I do not need to enter a date for that specific record, rather skip it) what do I designate as my skip code. I did have -77, but when I would enter that, it would say it was an illegal entry. How do I write the code, so that a skip is -77, and it still be a legal entry in some instances? legdat RANGE 01/01/1900 31/12/2008 LEGAL 30/12/2009 24/11/2008 END END (somewhere in there, I need to put it a skip code) Thank you for your time, Lindsay Lindsay Iser, M.A. University of South Florida Florida Mental Health Institute Department of Aging and Mental Health 13301 N. Bruce B. Downs BlVd. MHC 1403 Tampa, FL 33612 Tel-(813)-974-1975 Fax-(813)-974-1968 -----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: Thursday, November 13, 2008 1:10 PM To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 61, 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. Re: "Illegal entry" Dates (epidata-list(a)lists.umanitoba.ca) 2. charting developments in hospital infections - extension (epidata-list(a)lists.umanitoba.ca) 3. Re: Algorithm RUT, numeric field (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Wed, 12 Nov 2008 20:21:14 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] "Illegal entry" Dates To: epidata-list(a)lists.umanitoba.ca Message-ID: <491B2CAA.1090708(a)tbrieder.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed You cannot have illegal dates: 99, -77, 88 are not dates and if they were, they are not legal, there is no date that contains, e.g. "99". A command for a legal date range and legal date values should look something like this (using European date format here): legdat RANGE 01/01/1900 31/12/2008 LEGAL 30/12/2009 24/11/2008 END END Regards, Hans epidata-list(a)lists.umanitoba.ca wrote: > Provided below is the syntax. I've also made a few notes about the > error I am getting. I have tried several times to fix this, but for > some reason EpiData is telling me it is illegal. > > > > 1. fa163axxxx > > RANGE 01/01/1900 12/31/2008 > > LEGAL > > 99 > > -77 > > 88 > > END > > MUSTENTER > > END > > > -- Hans L Rieder, MD, MPH Jetzikofenstrasse 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://wwww.tbrieder.org ------------------------------ Message: 2 Date: Thu, 13 Nov 2008 00:18:43 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] charting developments in hospital infections - extension To: epidata-list(a)lists.umanitoba.ca Message-ID: <491B6453.9070802(a)epidata.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Regarding the most recent question to the list on MRSA infections, users could read these articles: Mohammed MA, Worthington P, Woodall WH. Results of a multicentre randomised controlled trial of statistical process control charts and structured diagnostic tools to reduce ward-acquired meticillin-resistant Staphylococcus aureus: the CHART Project.J Hosp Infect. 2008 Oct;70(2):127-35. Epub 2008 Aug 23. Curran E, Harper P, Loveday H, Gilmour H, Jones S, Benneyan J, Hood J, Pratt R. Results of a multicentre randomised controlled trial of statistical process control charts and structured diagnostic tools to reduce ward-acquired meticillin-resistant Staphylococcus aureus: the CHART Project.J Hosp Infect. 2008 Oct;70(2):127-35. Epub 2008 Aug 23. Borckardt JJ, Nash MR, Hardesty S, Herbert J, Cooney H, Pelic C. How unusual are the "unusual events" detected by control chart techniques in healthcare settings? J Healthc Qual. 2006 Jul-Aug;28(4):4-9. regards Jens Lauritsen EpiData Association ------------------------------ Message: 3 Date: Thu, 13 Nov 2008 08:20:31 -0500 From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Algorithm RUT, numeric field To: epidata-list(a)lists.umanitoba.ca Message-ID: <491C299F.3030509(a)sympatico.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed There is an example of this, based on the Danish CPR number on the Epidata web site: http://www.epidata.dk/examples.php The example is in English & Danish, with an explanation in English. You input the number as a single text field and then "take it apart" into its individual digits. Jamie Carlos wrote wrote: > I would like to know if I can read a numeric field and break down their > individual one-digit figure. > This, with the intention of obtaining the digit verifier (dv) of a RUT. > > I tried an algorithm, but I have to make individual fields for each digit, > > ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 61, Issue 7 *******************************************

1 2

Algorithm RUT, numeric field
by epidata-list＠lists.umanitoba.ca 13 Nov '08

13 Nov '08

I'm from Chile (South America), my native language is Spanis... I write a draft text below. Estimados amigos, Me gustaria saber si puedo leer un campo numérico y descomponer individualmente sus dígitos de aquella cifra. Esto, con la intención de obtener el digito verificador(dv) de un RUT. Intenté un algoritmo, pero tengo que hacer campos individuales para cada digito, que no es la idea, lo que hago es: R1# R2# R3# R4# R5# R6# R7# R8# -dv<A> entonces ingreso: 3 0 6 8 6 9 5 7 -dv 4(este surge del algoritmo) Me gustaria que fuese asi: RUT ######## -dv<A> (este surga del algoritmo) 30686957 -dv 4 Les agradesco mucha vuestra colaboración. Carlos Ortega Areyte Academico Procedimiento para obtener el dígito verificador. -------------------------------------------------- El RUT consta de dos partes, el número y el dígito verificador separados por un guión. En el siguiente ejemplo se toma como RUT el número 30.686.957- X, donde 30.686.957 es el número del RUT y X será el dígito verificador que se desea verificar o conocer: - Se procede a tomar el número de RUT de derecha a izquierda, multiplicando cada dígito por los números que componen la serie numérica 2,3,4,5,6,7; y sumando el resultado de estos productos, como se muestra a continuación (si se ha aplicado la serie hasta el 7 y quedan dígitos por multiplicar, se comienza la serie nuevamente): En el ejemplo: 7 × 2 = 14, 5 × 3 = 15, 9 × 4 = 36, 6 × 5 = 30, 8 × 6 = 48, 6 × 7 = 42, 0 × 2 = 0, 3 × 3 = 9, entonces la suma de los productos es: 14+15+36+30+48+42+0+9 = 194 - Al número obtenido por la suma del producto de cada dígito por la serie ya mencionada, se le aplica módulo 11, o sea, se divide por 11 y se determina el resto de la división. En el ejemplo: 194: 11 = 17 Resto: 7 Ahora a 11 se le resta el resto: En el ejemplo: 11 - 7 = 4 Si el resultado es 11, el dígito verificador será 0. Si el resultado es 10, el dígito verificador será K. En otro caso el resultado será el dígito verificador. Como en el ejemplo el resultado de la resta es 4, el dígito verificador es 4. Por ende, el RUT del ejemplo es el 30.686.957-4. Por cierto, este ejemplo lo Obtuve de es.wikipedia.org ************** ************** ******************************* This is a translation, I'm from Chile (South America), my native language is Spanish ... sorry my little English. Dear friends, I would like to know if I can read a numeric field and break down their individual one-digit figure. This, with the intention of obtaining the digit verifier (dv) of a RUT. I tried an algorithm, but I have to make individual fields for each digit, that is not the idea, what I do is: R1 # R2 # R3 # R4 # R5 # R6 # # R7 R8 # -dv <A> then login: 3 0 6 8 6 9 5 7 dv- 4 (this born from the algorithm) I would like it to be like this: RUT ######## -dv <A> (this born from the algorithm) 30686957 -dv 4 Thank you very much for your cooperation. Carlos Ortega Areyte Academic Obtain the procedure for verifying digit. -------------------------------------------------- The RUT is in two parts, the number and verifying digit separated by a hyphen. In the following example is taken as RUT number 30686957 - X, where 30686957 is the number of RUT and X will be the verifying digit you want to know or verify: - We shall proceed to take the number of RUT from right to left, by multiplying each digit numbers that make up the numerical series 2,3,4,5,6,7; and adding the output of these products, as shown below (if the series has been implemented and are up to 7 digits per leverage, the series begins again): In the example: 7 x 2 = 14 5 x 3 = 15, 9 × 4 = 36 6 x 5 = 30, 8 × 6 = 48 6 x 7 = 42 0 x 2 = 0, 3 x 3 = 9 then the sum of products is: 14 +15 +36 +30 +48 +42 +0 +9 = 194 - The number obtained by the amount of the proceeds of each digit in the series already mentioned, it is covered module 11, in other words, is divided by 11 and determining the rest of the division. In the example: 194: 11 = 17 Rest: 7 Now he is a 11 subtracts the rest: In the example: 11-7 = 4 If the result is 11, the verifier digit will be 0. If the result is 10, will be verifying digit K. Otherwise the result will be verifying digit. As in the example the result of the remainder is 4, the digit verifier is 4. Thus, the RUT's example is the 30.686.957- 4. this example of what I got es.wikipedia.org -- Carlos A. Ortega Areyte Prof. de Matemática y Computación Magíster en Bioestadística ACADÉMICO

1 1

charting developments in hospital infections - extension
by epidata-list＠lists.umanitoba.ca 12 Nov '08

12 Nov '08

Regarding the most recent question to the list on MRSA infections, users could read these articles: Mohammed MA, Worthington P, Woodall WH. Results of a multicentre randomised controlled trial of statistical process control charts and structured diagnostic tools to reduce ward-acquired meticillin-resistant Staphylococcus aureus: the CHART Project.J Hosp Infect. 2008 Oct;70(2):127-35. Epub 2008 Aug 23. Curran E, Harper P, Loveday H, Gilmour H, Jones S, Benneyan J, Hood J, Pratt R. Results of a multicentre randomised controlled trial of statistical process control charts and structured diagnostic tools to reduce ward-acquired meticillin-resistant Staphylococcus aureus: the CHART Project.J Hosp Infect. 2008 Oct;70(2):127-35. Epub 2008 Aug 23. Borckardt JJ, Nash MR, Hardesty S, Herbert J, Cooney H, Pelic C. How unusual are the "unusual events" detected by control chart techniques in healthcare settings? J Healthc Qual. 2006 Jul-Aug;28(4):4-9. regards Jens Lauritsen EpiData Association

1 0

"Illegal entry" Dates
by epidata-list＠lists.umanitoba.ca 12 Nov '08

12 Nov '08

Provided below is the syntax. I've also made a few notes about the error I am getting. I have tried several times to fix this, but for some reason EpiData is telling me it is illegal. 1. fa163axxxx RANGE 01/01/1900 12/31/2008 LEGAL 99 -77 88 END MUSTENTER END 1: i. No date will satisfy the commands. ii. When you do put a date it, it reads : "Illegal entry- Legal values are 01/01/1900-12/31/2008, -77, 99, 88" iii. I've tried to change the field type to date and have had difficulty making these changes. 2. fa163cxxxx RANGE 1/1/2004 1/1/2009 LEGAL -77 99 88 END MUSTENTER END 3. fa163exxxx RANGE 1/1/2004 1/1/2009 LEGAL -77 99 88 END COMMENT LEGAL USE nscid MUSTENTER END 2 and 3: i. No date will satisfy the commands. ii. When you do put a date it, it reads : "Illegal entry- Legal values are 1/1/2004-1/1/2009, -77, 99, 88" iii. I've tried to change the field type to date and have had difficulty making these changes. Thank you for your time!! Lindsay

1 1