November 2008 - EpiData-list - University of Manitoba Mailing Lists

Dealing with 'Ongoing' duration in epicurves
by epidata-list＠lists.umanitoba.ca 02 Dec '08

02 Dec '08

I would appreciate it if those working with outbreaks could reply about how they enter and display "ongoing" duration of illness. I have been given an Excel sheet to analyse in Epidata. For this outbreak people were asked the date and time when they became unwell and the date and time when they felt better. There is a calculated field in the spreadsheet that calculates duration in days (date better - date unwell), but for some people this is empty because "ongoing" has been entered as text in the "date better" field. I want to modify the Excel sheet so I include those people with 'ongoing' illness in an epidemic curve. I thought I could enter a date sometime in the future instead of 'ongoing' This would mean the duration days would not be blank, but a number of days well beyond the maximum value for those whose illness is finished. What do others do? thanks Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 2

Export to SPSS requires 2 stage procedure
by epidata-list＠lists.umanitoba.ca 30 Nov '08

30 Nov '08

Hello users and developers, I am using Epidata Entry 3.1 27 Jan 2008 on Windows XP Pro SP3. I have date entered in .REC files. When I perform the export function using the drop down menus, it does so fine, but the .SPS and .TXT files created are all blank. If I try re-exporting (with Epidata Entry still open), and error message pops up: "...data still in use..." or something like that. A successful data export to SPSS is only possible if I complete quite Epidata Entry and and start a new instance to perform the export procedure once again. Could somone please verify this for me, and if so please explain what is going on. It is quite frustrating that to have to do export in 2 stages. Thanks, Shuaib

1 0

Re: Test of a new "set" principle
by epidata-list＠lists.umanitoba.ca 27 Nov '08

27 Nov '08

The very quick message from N. Verlander was the observation that: set option means = ? option means not supported . set option means = "/t" OPTION MEANS = "/t" set option tables = ? tables sex kmgrp option tables = /t /r tables sex kmgrp /t /r (but the user wrote the same as above) The message of the default options NOT defined is correct. But we could/should most likely change the message from: option table not supported to option table not defined Another issue was that the option /t2 was not defined for Ichart. This will add two tests: test 4: 2 out 3 successive points more than 2 standard deviations (sigma) away from the centerline. test 5: 4 out of 5 successive points more than one standard deviation (sigma) away from the centerline. and currently also lines at 1 and 2 sigma from the centerline, but only for Ichart. A detailed document on respecification of spc charts is now available on the testing page. -- Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

Test of a new "set" principle and question on definition of SPC commands
by epidata-list＠lists.umanitoba.ca 27 Nov '08

27 Nov '08

At the test page http://www.epidata.dk/testing.php a new build (158) of EpiData Analysis has been placed for testing and commenting here on the list. The main new aspect is a change in user specifications for set commands as a consequence of the discussion on this list last week. For all commands each user can define his/her own options, e.g. if you desire row percentage and chi square tests always for tables add to your epidatastat.ini file: set option tables = "/t /r" If you have the custom instead to use the short form of tables you would write: set option tab = "/t /r" Two "command group" set commands are predefined: set OPTION GRAPH (all graphs excluding SPC graphs) set OPTION SPC (SPC charts including pareto chart and run chart) Another area for testing is the extended SPC definitions, with new graphs: ichart /mr, gchart, cchart,uchart and ichart /t2 A suggestion has been made to change SPC charts such that the "time" variable is only used when the user specifically wishes to do so. It is expected that after a certain build/release the syntax for SPC charts will be: Xbar-S measurement‭ ‬time Ichart measurement‭ [‬time‭/label]* Uchart count volume ‭[‬time/label‭]* Cchart count‭ [‬time‭/label]* Pchart count total‭ [‬time‭/label]* Gchart "time at‭ ‬incident‭"‬ (only one variable) Pareto categories‭ Where [time/label]* indicates that this variable is NOT mandatory. If given this will be used as a label (like /xlabel), when the variable is string and as a value for x when it is numerical. Comments to this change are welcomed. -- Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

Documentation of lifetable updated
by epidata-list＠lists.umanitoba.ca 27 Nov '08

27 Nov '08

Branger pointed out that the documentation on lifetable command in latest analysis was faulty. An updated version of commands.htm has been uploaded and can be found at: http://www.epidata.dk/commands.htm#lifetabgrp The file will be added to install versions later. Estimation options: /time=x :Calculate Survival estimate at indicated time value (values) /p25 p50 p75 :Calculate Time span estimates at Quartiles and Median of Survival Proportions (0.75 0.5 0.25) /t : Log-rank test and Hazard Ratio (only relevant with /by) /ref=x : Indicates value of /by variable to use as reference for comparisons when the difference from reference is estimated for /time /p and /t options The option /G has been replaced with /NG to hide the graph., but was incorrect in the documentation. Hide/show: * /NG do notshow the Kaplan Meier plot * /NT : do not show summary documentation table * /NOLT: do not show lifetable * /E0 /E1 /E2 /E3 /E4 : show results with this number of decimals * /NOCI : Hide confidence intervals in tables and graph (e.g. if graphs overlap for groups) regards Jens Lauritsen EpiData Association

1 0

Epidata
by epidata-list＠lists.umanitoba.ca 26 Nov '08

26 Nov '08

Hello, I have a problem with relate for two related files (with merge command), and its OK with EPI INFO 6 (DOS) The key is fiche. I wrote these commands (I simplify) : read first.rec merge fiche /file=second.rec and is written : Non-unique key in: second.rec The two files .chk are : - first.rec FICHE KEY UNIQUE END ONEVAR IF ONEVAR=1 THEN RELATE FICHE SECOND.REC ENDIF END - second.rec FICHE KEY 1 END Thank you PS : In lifetable Help /haz and /G are notified but these commands are not effective Bernard BRANGER - Médecin coordinateur Réseau de Santé en Périnatalité "Sécurité Naissance - Naître ensemble" des Pays de la Loire 1, allée Baco - 44000 NANTES Tél 02 40 48 55 81 - Fax 02 40 12 40 72

1 1

Numeric Range for field (two ranges)
by epidata-list＠lists.umanitoba.ca 26 Nov '08

26 Nov '08

1. Numeric Range for field (epidata-list(a)lists.umanitoba.ca) > Hello, > In the .chk file, I want to define a range for a numeric field (v1 ###) as follows: 100-120, 200-250 > Easiest solution: v1 range 100 250 after entry if (v1 > 120) and (v1 < 200) then help "Range allowed: 100-120 or 200-250" goto v1 endif end end Regarding the other question yesterday on loss of date we need to know more. regards Jens Lauritsen EpiData Association

1 0

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

sort field
by epidata-list＠lists.umanitoba.ca 11 Nov '08

11 Nov '08

I have 300 records, each was stored in a disorderly file, "failure.REC" So, when I preview the records, in step 5.Document (view data) this showing: id age sex event 2 0 1 25 80 1 1 28 125 0 1 36 3 1 1 19 18 0 1 44 23 0 0 12 . . . 10 0 0 21 300 0 1 39 287 1 0 58 1 0 1 23 How can I get these same records appear sorted by id, in the file failure.REC when I try to enter an new records? So when you enter the id 300, so this can then enter the id 300? I managed this trick, STATA by exporting to ... order by id, the new failure.dta Then, import failure.dta to a new failure.REC ... I am working. But it's also complicated and I do not retain the original format, let alone id ###### sex ###### event ###### age ###### erasing {id} What is the id of the questionnaire? # # # {sex} Indicate sex # {event} What is the patient's condition at the end of the period? # {age} Age at onset of the study # # I hope you understand my question. Carlos Ortega A. Biostatistics

1 1

Charting SPC (statistical process control) data with EpiData Analysis
by epidata-list＠lists.umanitoba.ca 09 Nov '08

09 Nov '08

Shakeel asked on the list: "Is there any way I can create SPC Charts that show actual counts (e.g of MRSA) against targets?" There are three SPC strategies here, depending on the frequency of MRSA infections: 1. If rare: Record date of incidence (e.g. dateinci) and save in a rec file, then in analysis (latest test release): read mrsadata ; Gchart dateinci /t 2. If a certain proportion of patients. Record dates (e.g. hospdate) number of infections (count) and total volume of patients (total): read mrsadata ; pchart hospdate count total /t 3. If you only have the counts, but not the totals, you can either do a runchart or ichart: read mrsadata ; runchart hospdate count /t ; Ichart hospdate count /t; In other words it depends on the nature of the contact to the patients, the similarity of the underlying data in subgroups etc. For adding the target an option with the graphs is required, e.g.: Say the target was 1 % of all patients with a certain infection: pchart hospdate count total /t /yline=0.1 /sub="Target indicated at Y=10%" A good advice is always regardless of the above, that a lot can often be learned by just plotting the raw data on a time scale. A "manual" for SPC is underway, but meanwhile read some of the textbooks available. regards Jens Lauritsen EpiData Association

1 0

Selecting Dates
by epidata-list＠lists.umanitoba.ca 08 Nov '08

08 Nov '08

Hello Could you please advise what I am doing wrong with my date selection process. I have a field called visitdate. Format = dd/mm/yyyy. The field itself is OK because FREQ visitdate works fine. My problem is when I try to select dates less than 1 July ( 01/07/2008) When I try select visitdate < "01/07/2008" I get an error message "Type Date is incompatible with type String operation aborted" When I try select visitdate < 01/07/2008 I get an error message "Type Date is incompatible with type Float Operation aborted" The only way I could find in the end was to use the month function to create a new field called visitmonth from visitdate and then select visit month <7. This worked, but I want to be able to select on the original visitdate field. Could someone help please? thanks Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 >>> <epidata-list-request(a)lists.umanitoba.ca> 29/11/2007 7:02 a.m. >>> 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..." -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 1

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

07 Nov '08

I will be out of the office starting 11/07/2008 and will not return until 11/10/2008. If you require immediate assistance, please contact Celina Sousa at extension 5300. Thanks and have a nice weekend, Alyshia

1 0

Epidata Analysis 2
by epidata-list＠lists.umanitoba.ca 07 Nov '08

07 Nov '08

Hello, Three suggestions on last version of Epidata Analysis 2.0 (very good on the whole): - a regression line in scatter graph is imperative like EPI 6 and all the statistic softwares ++ - a few "set command" are desirable; for example : * "set statistics = on" instead to write /t for all the commands * "set table percentage = row" instead to write /r for all the "tables" commands - "set freq percentage= column" instead to write /c for all "freq" commands A question about "lifetable" command (very useful and pratical) : - In understand that the method is "actuarial" ou "lifetable" with a range of time for the calculation of probability (1 by default). The result is the same than SPSS with the command "lifetable" and time range = 1. It's not Kaplan-Meier method because the probability is not calculated at each event, (or calculation of remaining number at each censored data). Thank you your observation. B. BRANGER. PS : I modify this week the help on my site www.reseau-naissance.fr <http://www.reseau-naissance.fr/>

1 0

Epidata with lynux
by epidata-list＠lists.umanitoba.ca 04 Nov '08

04 Nov '08

How can I use Epidata with Lynux?

1 1

Options versus set
by epidata-list＠lists.umanitoba.ca 03 Nov '08

03 Nov '08

I am more than just in favor of options, I believe that they are the best possible approach, it makes everything so straight forward and simple. Sometimes we want something to test, then we do it with the option, else we take it out, and it is all in the same command line, rather than a "set xx=on" then the command, then "set xx=off" again. Options are very intuitive. Hans

1 0

Default behaviour of EpiData Analysis
by epidata-list＠lists.umanitoba.ca 02 Nov '08

02 Nov '08

There will always be differences as to how users wish to run different commands. Some time ago a discussion was on the list regarding the list. The decision was to move as much as possible to options, since otherwise the users have to issue different commands for changes. As was suggested by B.Branger why not "get back" the "set statistics", "set table percentage" etc. The problem of this is the implementation in the menu system (dialogs), which becomes a bit messy. The suggestion for users is rather to use the following technique: Add to your epidatastat.ini: define tableoption __________ global tableoption = " /t /R /C" // or whatever you prefer or shorter: define t __________ global t = " /t /R /C" // or whatever you prefer Now in your actual pgm file or at the command line, just issue: tab v1 v2 @t You might say "a bit annoying" to add @t, but still less than writing the options. Another aspect of the issue is that the set definitions mentioned are part of the Epi Info v6 specification, but many users who did not do statistical analysis with Epi6 are not aware of this by now. regards Jens Lauritsen Epidata Association

1 0

about: Lifetable in v2.1
by epidata-list＠lists.umanitoba.ca 02 Nov '08

02 Nov '08

B.Branger questioned whether the lifetable is "actuarial" or "Kaplan-Meier" principle. The principle is to calculate changes in survival probabilities at each date, where a change happens - either censoring or case status. In actuarial calculations there would be an aggregation to say half year, month or similar. Therefore if you DO NOT use the /i for "Interval" the calculation will be "Kaplan-Meier" technique. If you found an example where this is not the case let us know. regards Jens Lauritsen EpiData Association

1 0

Epidata Analysis 2
by epidata-list＠lists.umanitoba.ca 02 Nov '08

02 Nov '08

Hello, Three suggestions on last version of Epidata Analysis 2.0 (very good on the whole): - a regression line in scatter graph is imperative like EPI 6 and all the statistic softwares ++ - a few "set command" are desirable; for example : * "set statistics = on" instead to write /t for all the commands * "set table percentage = row" instead to write /r for all the "tables" commands - "set freq percentage= column" instead to write /c for all "freq" commands A question about "lifetable" command (very useful and pratical) : - In understand that the method is "actuarial" ou "lifetable" with a range of time for the calculation of probability (1 by default). The result is the same than SPSS with the command "lifetable" and time range = 1. It's not Kaplan-Meier method because the probability is not calculated at each event, (or calculation of remaining number at each censored data). Thank you your observation. B. BRANGER. PS : I modify this week the help on my site www.reseau-naissance.fr <http://www.reseau-naissance.fr/>

1 0

Update for EpiData Analysis v2.1 and news on further development.
by epidata-list＠lists.umanitoba.ca 02 Nov '08

02 Nov '08

A new build for EpiData Analysis has been placed for general download. From v2.1.0.154 it is possible to give dates as a parameter to x-axis limits in EpiCurve and Kaplan Meier Survival plots. e.g. Epicurve outcome dayonset /xmin="01/10/1986" /xmax="25/10/1986" Notice the DMY format. A few other bugs have been solved. If you are not using Epicurve there is no reason for updating. A recent seminar in Canada forms part of the intensified development ongoing this year. This collaboration is with the Assocation of Public Health Epidemiologists in Ontario, Canada, see: http://www.apheo.ca/index.php?pid=47 On the testing page (http://www.epidata.dk/testing.php) v2.1.1.154 includes two new commands released for tests and comments: xbar /Range, xbar /Sigma , and ichart /MR - these will perform double charts used in Statistical Process Control analysis and visualisation. An extended user manual is in development and expected ready for general use in about one month. G-charts are expected within 1-2 weeks for testing. Regards Jens Lauritsen EpiData Association

1 0