- EpiData-list - University of Manitoba Mailing Lists

Re: EpiData-list Digest, Vol 42, Issue 5
by epidata-list＠lists.umanitoba.ca 12 Apr '07

12 Apr '07

Dear Ali, It seems to be a simple task. First, as far as I know the BMI is calculated as weight/(heigh*heigh). However this values should be in Kg and m. If you have the data in pounds and feet, then youl should transform them before. To make it easier, create a variable in the qes file with this information. qes file v1 heigh in feet ##.# v2 heigh in m #.## v3 weight in pound ###.## v4 weight in Kg ###.# v5 bmi ##.## chk file v1 after entry let v2 = round(v1*0,4536) end end v2 noenter end v3 after entry let v4=round(v3/3,28) end end v4 noenter end v5 before entry let v5=v4/(v2*v2) goto v6 end end I hope this works fine for you because didnt test it! ;) Succes, Pedro Emmanuel Brasil 2007/4/12, epidata-list-request(a)lists.umanitoba.ca < epidata-list-request(a)lists.umanitoba.ca>: > > 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. BMI Calculation (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 12 Apr 2007 08:12:37 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] BMI Calculation > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <9aeb5bc30704120512q55329040pc02a85328844f8d1(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Thanks. > I just recently started using Epidata, and I need some help on creating a > Check string for automatically calculating BMI using Weight and Height (in > pounds and feet/inches). Thanks, again. > > > > -- > Ali B. Mansaray > MANSA Consulting Services > 6530 Davidson Road > Columbia, SC 29209 > 803-381-6864 > ali.mansaray(a)gmail.com > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 42, Issue 5 > ******************************************* >

1 1

How to get appropriate stats - correction
by epidata-list＠lists.umanitoba.ca 08 Apr '07

08 Apr '07

Apologies. Part of my previous request about appropriate stats would not have made sense as I have subsequently realised that adding /f gives frequencies of the variables. Please bear with me and consider my revised question around the issue on how to get the appropriate stats. I would like to get the Fischer Exact p value, as well as the CI values as part of my table output. I looked in the help function and the command options do not seem to match up with the explanations. There is supposed to be an option that says 'add an extra table with a summary of chi square, p values etc' but I can't find the appropriate command on the LHS. I have been able to get the Fischer's exact p by using the command /EX but the command /CI didn't give me any confidence intervals. (I am using build 108). Thanks. Juanette -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to CallCentre(a)csir.co.za. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Changing confidence intervals & getting appropriate stats
by epidata-list＠lists.umanitoba.ca 05 Apr '07

05 Apr '07

I sent a request on the 29th of March asking how one could change CI to reflect 90% instead of 95% which I assume is the default. I am working in Epidata Analysis V2.0 (build 108). Someone suggested to add the following command: Set TABLE CI HEADER="(90% CI)", which I've tried. It does change the header to reflect 90% but the actual CI values still stays the same. I would also like to get the Fischer Exact p value, as well as the CI values in the table. The only way I've been able to get these, has been to put in the following command: tables var1 var2 /EX /CI /f (see below). But then it gives me two tables, which I am not sure how to interpret. .tables diarrh numtous2 /EX /CI /F Any member of family suffered of DIARRHOEA during last month? N % (90% CI) ........ only header changed, not values underneath 1 9 2.4 (1.3-4.5) 2 368 97.6 (95.5-98.7) Total 377 100.0 NUMTOUS2 N % (90% CI) <5 182 49.3 (44.3-54.4) 5&MORE 187 50.7 (45.6-55.7) Total 369 100.0 Thanks. Regards Juanette -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to CallCentre(a)csir.co.za. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

First word or Automatic Field Names
by epidata-list＠lists.umanitoba.ca 05 Apr '07

05 Apr '07

I am interested as to why the default setting for Epidata for Field names is first word. I assume because it is the default setting that it is the most commonly used. Do other people use the first word setting when developing questionnaires? I have always used the automatic field names settings. I use Epidata mainly for outbreak questionnaires. For these we ask standard questions each time 1. descriptive details about the person 2. information about the pattern of illness 3. information about the things (usually food) that a person has been exposed to Becuase you have to develop questionnaires quickly when there is an outbreak I have a 'master file' which is like a template. When there is a new outbreak I just change the exposures and save it as a new name. The following is a sample of what part of the epidata qes file would look like: First name __________ Last Name _________ Sex <A> DOB <mm/dd/yyyy> Ill <Y> Diarrhoea <Y> OnsetDate <mm/dd/yyyy> Ham <Y> Beef <Y> Chicken <Y> What would be the advantage of using the first name setting? It would mean the field for the first name in the example above would be 'First'. I have seen people develop questionnaires that use say V1 as the field and Ham as the label. But it seems to be to be much easier to analyse data when the field name is self explanatory. I give other people the advice to set up their questionnaire like I have and I don't want to be telling them the wrong thing, so would be interested to know what other people 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

Duplicate files
by epidata-list＠lists.umanitoba.ca 04 Apr '07

04 Apr '07

Hello I have entered my data twice on epi data and would now like to validate files to make sure that my data is accurate. I have different ID numbers so can not run on Id keys but I have entered the data in the same order so the record numbers match. I have 1 deleted record in one database which I have adjusted for but checking the box that says ignore deleted records. I have 126 records in total when I go to validate files it comes up with an error box saying that it cannot create log file. Does anyone have any ideas on how this could be fixed. Thanx aysha

1 2

Printing forms
by epidata-list＠lists.umanitoba.ca 02 Apr '07

02 Apr '07

Helo all, Recently I was involved in a clinical trial in one center. Because of that I had to read some new stuff and to have classes of good clinical practices and about the ICH (International conference on harmonization). There are some stuff about these regulatory good clinical practice that I woul like to put on the list but for now a more pratical issue. Because of these regulatory resolutions, the research have to keep the clinical forms on paper, dated and signed by those who fill them. Since the clinical interview and evaluation will be made in offices where computer are easily accessible, then it would be easier if the professionals fill the forms on the computer an right after to print them. And only then sign and date the forms. There is a print option in the file menu while the enter data is open. However I would like to turn it automatic. Such as at the end of the form, while saving in the file, epidata would automaticlly send the form to the printer. As far as I could look for, I didnt find any chk command that would satisfy my wishes. So, I was figuring out to put a warning message, but it wouldnt work the same way. Any one with a tip to work around? Thank you, Pedro Emmanuel Brasil -- Abraço forte e que a força esteja com você, Pedro Emmanuel

1 0

Re: EpiData-list Digest, Vol 41, Issue 12
by epidata-list＠lists.umanitoba.ca 29 Mar '07

29 Mar '07

Dear Aysha, Not having an ID number is a fatal error that may compromize a lot of stuff in the analysis. By now U must have figured out that the best strategy would be a ID number generated by you and have the same ID number on the pair file. I did the same error and learned making mistakes and having to do all again sometimes in the past. I assume that U have the exact same 126 forms digitized twice in differrent files! If You have them all in the same order somethings can be done to work arround. The first sugestion, since it seems to bem few records, is to digitize a third time using the validate double files in the tool menu. (Im not shure if I can call like this because my menus are in portuguese) At this tool EpiData creates a second file with the same name with the extension yourfile_dbl.rec. Enter data in this file and U will see that as U put the data in the file it will show the difference of th first file and then ask if want to keep the new value or the old value! This one takes work thouh! The second work arround that I can imagine is that U may create a new variable in the qes file that would be the ID, update the rec file, enter the new unique IDs and the same ID inthe mirror file. A more clever one is to export your two files to other format such as STATA or xls and then create a new sequencial variable such as 1 to 126, doing the same with the mirror file. Watch out for mistakes here, beacause if U do mistakes it may be hard to find where it is! Then import them again inthe Epidata format an now compare them! If U work with STATA, it also have tool to compare datasets. Im shure that SAS and SPSS or R also have similar tools. I hope it helps you! Good luck, Pedro Emmanuel Brasil 2007/3/29, epidata-list-request(a)lists.umanitoba.ca < epidata-list-request(a)lists.umanitoba.ca>: > > 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. Duplicate files (epidata-list(a)lists.umanitoba.ca) > 2. Changing Confidence Intervals on EpiData Analysis > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 28 Mar 2007 16:28:37 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Duplicate files > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <7AC047D44A8CD243B7FE9305102D5FD105D96B27(a)MAIL.bc.iop.kcl.ac.uk> > Content-Type: text/plain; charset="us-ascii" > > Hello > > I have entered my data twice on epi data and would now like to validate > files to make sure that my data is accurate. I have different ID > numbers so can not run on Id keys but I have entered the data in the > same order so the record numbers match. I have 1 deleted record in one > database which I have adjusted for but checking the box that says ignore > deleted records. I have 126 records in total when I go to validate > files it comes up with an error box saying that it cannot create log > file. > > Does anyone have any ideas on how this could be fixed. > > Thanx > aysha > > > ------------------------------ > > Message: 2 > Date: Thu, 29 Mar 2007 10:51:36 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Changing Confidence Intervals on EpiData > Analysis > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <460B9A38020000770000C4B6(a)cs-emo.csir.co.za> > Content-Type: text/plain; charset=US-ASCII > > Hi, I would like the stats I get when doing an epitable to to reflect a > 90% CI, instead of the default 95%. Is it possible to do so, and if yes, > how? > > Thanks! > > REgards > Juanette John > > Natural Resources & the Environment - CSIR > PO Box 395 > Pretoria > 0001 > South Africa > jjohn(a)csir.co.za > Tel 27 12 841 4189 (mornings only) > Cell 083 4100 444 > Fax 27 12 841 4257/086 6180084 > > CSIR: "our future through Science" > http://www.csir.co.za > > -- > This message is subject to the CSIR's copyright, terms and conditions and > e-mail legal notice. Views expressed herein do not necessarily represent > the > views of the CSIR. > > CSIR E-mail Legal Notice > http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html > > CSIR Copyright, Terms and Conditions > http://mail.csir.co.za/CSIR_Copyright.html > > For electronic copies of the CSIR Copyright, Terms and Conditions and the > CSIR > Legal Notice send a blank message with REQUEST LEGAL in the subject line > to > CallCentre(a)csir.co.za. > > > This message has been scanned for viruses and dangerous content by > MailScanner, > and is believed to be clean. > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 41, Issue 12 > ******************************************** > -- Abraço forte e que a força esteja com você, Pedro Emmanuel

1 0

Re : EpiData-list Digest, Vol 41, Issue 12
by epidata-list＠lists.umanitoba.ca 29 Mar '07

29 Mar '07

Hello Juanette John You will make that to execute the following command [ set TABLE CI HEADER="(90% CI)" ] and after all the proportions will have IC 90 % Thank you ___________________________________________ Dr Jean-Paul DIBY-KONAN Médecin Santé Publique MCM Santé de la Reproduction Institut Médecine Tropicale Kapucinessenstraat 8 B-2000 Anvers Belgique ----- Message d'origine ---- De : "epidata-list-request(a)lists.umanitoba.ca" <epidata-list-request(a)lists.umanitoba.ca> À : epidata-list(a)lists.umanitoba.ca Envoyé le : Jeudi, 29 Mars 2007, 19h02mn 31s Objet : EpiData-list Digest, Vol 41, Issue 12 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. Duplicate files (epidata-list(a)lists.umanitoba.ca) 2. Changing Confidence Intervals on EpiData Analysis (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Wed, 28 Mar 2007 16:28:37 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Duplicate files To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <7AC047D44A8CD243B7FE9305102D5FD105D96B27(a)MAIL.bc.iop.kcl.ac.uk> Content-Type: text/plain; charset="us-ascii" Hello I have entered my data twice on epi data and would now like to validate files to make sure that my data is accurate. I have different ID numbers so can not run on Id keys but I have entered the data in the same order so the record numbers match. I have 1 deleted record in one database which I have adjusted for but checking the box that says ignore deleted records. I have 126 records in total when I go to validate files it comes up with an error box saying that it cannot create log file. Does anyone have any ideas on how this could be fixed. Thanx aysha ------------------------------ Message: 2 Date: Thu, 29 Mar 2007 10:51:36 +0200 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Changing Confidence Intervals on EpiData Analysis To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <460B9A38020000770000C4B6(a)cs-emo.csir.co.za> Content-Type: text/plain; charset=US-ASCII Hi, I would like the stats I get when doing an epitable to to reflect a 90% CI, instead of the default 95%. Is it possible to do so, and if yes, how? Thanks! REgards Juanette John Natural Resources & the Environment - CSIR PO Box 395 Pretoria 0001 South Africa jjohn(a)csir.co.za Tel 27 12 841 4189 (mornings only) Cell 083 4100 444 Fax 27 12 841 4257/086 6180084 CSIR: "our future through Science" http://www.csir.co.za -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to CallCentre(a)csir.co.za. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 41, Issue 12 ******************************************** ___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com

1 0

Changing Confidence Intervals on EpiData Analysis
by epidata-list＠lists.umanitoba.ca 29 Mar '07

29 Mar '07

Hi, I would like the stats I get when doing an epitable to to reflect a 90% CI, instead of the default 95%. Is it possible to do so, and if yes, how? Thanks! REgards Juanette John Natural Resources & the Environment - CSIR PO Box 395 Pretoria 0001 South Africa jjohn(a)csir.co.za Tel 27 12 841 4189 (mornings only) Cell 083 4100 444 Fax 27 12 841 4257/086 6180084 CSIR: "our future through Science" http://www.csir.co.za -- This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice. Views expressed herein do not necessarily represent the views of the CSIR. CSIR E-mail Legal Notice http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html CSIR Copyright, Terms and Conditions http://mail.csir.co.za/CSIR_Copyright.html For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice send a blank message with REQUEST LEGAL in the subject line to CallCentre(a)csir.co.za. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

1 0

Using Notes for long text fields
by epidata-list＠lists.umanitoba.ca 15 Mar '07

15 Mar '07

Hi Pedro, that's a good point. I'll try to figure that out. It seems to me that Epidata was not really developed for dealing with long text fields. Nevertheless, many questionnaires have such questions, e.g. a concluding question in which the respondent can comment on the contents of the questionnaire and this often leads to long and very interesting comments. It would ofcourse be nice if such and other long text answers could simply be processed with Epidatal. Maybe this will become more easy in a future release? Who knows. Bye and thanks, Ben.

1 1