April 2007 - EpiData-list - University of Manitoba Mailing Lists

Getting values from other records (was: create reduced dataset with EpiData Analysis): long to wide conversion
by epidata-list＠lists.umanitoba.ca 30 Apr '07

30 Apr '07

Hans wishes to get from SET12.REC with variables: ID AGE SEX VAR1 VAR2 - where each person (ID) have four records which we each call one visit to NEWSET.REC with variables: ID AGE SEX VAR11 VAR21 VAR12 VAR22 VAR13 VAR23 VAR14 VAR24 where each person (ID) have one record This conversion can be named "From long to wide format" and is a conversion we often wish to work on: In the example it is quite easy, since it seems that there are exactly four visits per person. One way of doing this is: (principle must be tested on actual data) read set12.rec freq id // here I would look to make sure that all id's actually had four records * We assume that the order of visits in set12 is chronological, but wish to have an identifier: gen i visit = 1 // integer variable with value 1 for all if id = id[_n-1] then visit = visit[_n-1] + 1 // now the value of visit is correct 1 2 3 4 * the [_n] indicates recnumber and by subtracting one "_n-1" we get the previous record browse // here I would look to control that the calculation was correct * generate the 8 variables: (you could also use define followed by let ) gen var11 = -1 ..... etc until gen var24 = -1 * the reason for the value -1 is that we wish to know if the variable is changed later. Sort id visit * now we can move the values to the correct variable: (shown for the var11..var14) if visit = 1 then var11 = var1 if visit = 1 then var12 = var1[_n+1] if visit = 1 then var13 = var1[_n+2] if visit = 1 then var14 = var1[_n+3] * and similarly for the var2x variables browse // to see visually that it works * all values have now been copied from four records to the first record for each person select visit = 1 labeldata "My combined file in wide format" savedata newfile The principle above can be used for many conversions. E.q. for first and follow up visit: * assume bmi indicates body mass index. And we wish to test for bmi change by sex: gen bmidif = . if (visit = 1) and (id = id[_n+1]) then bmidif = bmi[_n+1] - bmi means bmidif sex // for testing in version 2 add /t The next question could be "How to get from wide to long format" - The reverse of what Hans wanted. This would not be quite as easy, but something like generate 400 // an empty file first, e.g. 100 observations with four records gen i s = _n // instead of _n recnumber can be used gen i id = 1 if (s mod 4) = 0 and (recnumber > 4) then id = id[_n-4] + 1 * plus some more logic to get the id numbers right. * then the data could be added by "relate" and subsequently moved to the correct variables regards Jens Lauritsen

1 2

Getting values from other records - long to wide conversion - continued
by epidata-list＠lists.umanitoba.ca 30 Apr '07

30 Apr '07

Marcel extended the example by asking: Is there a way to make sure that the data set is sorted to be sure that the assumption: "* We assume that the order of visits in set12 is chronological, holds" ? I recommend having a time in the "visits record", preferably: e.g. datevisit, but also a sequential number in patient follow up studies, e.g.visit 1=start 2=4monts 3=12 months 4=2years etc. In real empirical data it usually happens that one or more visits are either missed or taking place at a point in time not exactly being on time. E.g. how to designate a visit 5 monts after initial treatment in a study where visits are supposed to be at 4 and 6 months. Sequence often indicates certain tests (e.g. blood samples) which vary by visit, e.g. more expensive ones less often, such as x-rays. By using as well the date and the sequence we can know exactly what are the data, which variables are missing and what is the time difference from "supposed time of visit". Therefore careful planning obviously remedies this by having the possibility to sort as well on sequence and date. sort id visit In the control of such data I would always: read rawdata *suppose we need 4 visits per person, numbered 1 2 3 4 * 1+2+3+4=10 aggregate studyid /sum="visit" /close gen i ok=(sumvisit=10) list studyid visit if ok <> 1 * or the same in "epi6" mode: read rawdata aggregate .... as above... define ok # let ok = 0 if (sumvisit = 10) then ok = 1 select if ok <> 1 list studyid select regards Jens Lauritsen

1 0

Create reduced dataset with EpiData Analysis
by epidata-list＠lists.umanitoba.ca 28 Apr '07

28 Apr '07

I have a parent SET1.REC, containing a key unique identifier ID and AGE and SEX, related to child SET2.REC, containing VAR1 and VAR2 In analysis, I create SET12.REC that has now as many records as SET2 (ID, AGE, and SEX) repeated for each record up to as many times as there are values for VAR1 and VAR2. If SET1 actually represents the individuals identified by ID, and SET2, e.g., visits for ID, and I wish now to make a NEW.REC containing only as many records as there are IDs, but making new variables VAR11, VAR21, VAR12, VAR22, and VAR13, VAR23, VAR14, VAR24 (if there are up to 4 visits for each ID, HOW would one thus write an EpiData Analysis command set to get from: SET12.REC ID AGE SEX VAR1 VAR2 to NEWSET.REC ID AGE SEX VAR11 VAR21 VAR12 VAR22 VAR13 VAR23 VAR14 VAR24 (where I know there is a maximum of 4 visits per ID) with only ID number of records? Thank you for any input you might have, Hans -- Hans L Rieder, MD, MPH Jetzikofenstr. 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org

1 0

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

26 Apr '07

bonjour veullez ne plus m'envoyer de messages!!!merci ----- 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 : Mardi, 24 Avril 2007, 19h03mn 39s Objet : EpiData-list Digest, Vol 42, Issue 14 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. Is there any way to import from Excel to EpiData? (epidata-list(a)lists.umanitoba.ca) 2. Re: Is there any way to import from Excel to EpiData? (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Tue, 24 Apr 2007 10:48:18 +0200 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Is there any way to import from Excel to EpiData? To: <epidata-list(a)lists.umanitoba.ca> Message-ID: <939234DEF7B61C48B044D11A67E61B748A3EDE(a)mdmexch.medecinsdumonde.net> Content-Type: text/plain; charset=iso-8859-1 Hello everyone. I understand from the user manuals that data can be imported from text, dbase, and STATA. Has anyone figured out a way to import an Excel database, even though technically it is not an option? Thank you Todd Services Technique d'Appui aux Opérations (STAO) Médecins du Monde - France 62 rue Marcadet 75018 Paris - France Tél: +33 (0)1 44 92 16 18 ------------------------------ Message: 2 Date: Tue, 24 Apr 2007 05:41:32 -0700 (PDT) From: epidata-list(a)lists.umanitoba.ca Subject: Re: [EpiData-list] Is there any way to import from Excel to EpiData? To: epidata-list(a)lists.umanitoba.ca Message-ID: <467108.92422.qm(a)web43141.mail.sp1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 You can save the Excel file as a .dbf file, then import the .dbf file into Epidata. I assume you'll need to add variable names in the first row of the Excel file. Richard Herrell NIMH epidata-list(a)lists.umanitoba.ca wrote: Hello everyone. I understand from the user manuals that data can be imported from text, dbase, and STATA. Has anyone figured out a way to import an Excel database, even though technically it is not an option? Thank you Todd Services Technique d'Appui aux Opérations (STAO) Médecins du Monde - France 62 rue Marcadet 75018 Paris - France Tél: +33 (0)1 44 92 16 18 _______________________________________________ EpiData-list mailing list EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 42, Issue 14 ******************************************** ___________________________________________________________________________ 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 1

Is there any way to import from Excel to EpiData?
by epidata-list＠lists.umanitoba.ca 25 Apr '07

25 Apr '07

Hello everyone. I understand from the user manuals that data can be imported from text, dbase, and STATA. Has anyone figured out a way to import an Excel database, even though technically it is not an option? Thank you Todd Services Technique d'Appui aux Opérations (STAO) Médecins du Monde - France 62 rue Marcadet 75018 Paris - France Tél: +33 (0)1 44 92 16 18

1 3

Anyone working on EpiData in Johannesburg
by epidata-list＠lists.umanitoba.ca 22 Apr '07

22 Apr '07

Hi, I wrote introductory guideline for EpiData at Karolinska Institute, Stockholm. Now I am in Johannesburg for data collection, will spend around 10 months here. People working in bioinformatics are interested in learning more about EpiData and was asked to present about database. Anyone living in Johannesburg and interested in joining to teach EpiData? Best regards ziad -- Ziad El-Khatib AIDS Unit National Institute for Communicable Diseases (NICD) 1 Modderfontein Road Private Bag X4, Sandringham, 2131 Johannesburg, South Africa Mobile: +27 (0) 72-52 39 716 Phone: +27 (0) 11-386 6433 Fax: +27 (0)11 386 6453 http://www.nhls.ac.za/div_nicd.html Division of International Health (IHCAR) Karolinska Institutet www.phs.ki.se/ihcar

1 0

Re: Defining confidence intervals in analysis
by epidata-list＠lists.umanitoba.ca 19 Apr '07

19 Apr '07

> > >I would like to know how one could change the confidence Interval (CI) > to reflect 90% instead of 95% which I assume is the default. I am > working in Epidata Analysis V2.0 (build 108). > > The command "set table CI HEADER="(90% CI)" only changes the text in the tables, not the calculation. Until now the statistics have NOT been adapted to other confidence intervals than 95%. For a given table it should be quite easy though given you have the raw numbers. Enter these into e.g. www.openepi.com and get the desired 90% CI. For analysis the possibility of users defining CI (e.g. 90 95 99) could be implemented within the next few years. Just now for the v2 of EpiData Analysis we are working on some "subtle" internal issues, which is why seemingly very little progress was made recently. The implementation of the Upper Case fields <AAAAA> revealed need for quite many changes, since all internal parts were made only for uppercase handling. The problems mentioned in the Mantis database and on the www.epidata.dk/testing.php page that the latest test build does not save data properly has been solved. Regards Jens Lauritsen EpiData Association

1 0

Confidence intervals and stats
by epidata-list＠lists.umanitoba.ca 19 Apr '07

19 Apr '07

Hi again I sent a request on the this earlier but I don't know if everyone was on holiday because I didn't get any response:-)! So I am trying again! I would like to know how one could change the confidence Interval (CI) to reflect 90% instead of 95% which I assume is the default. I am working in Epidata Analysis V2.0 (build 108). If one uses the command: Set TABLE CI HEADER="(90% CI)", it does change the header to reflect 90% but the actual CI values still stays the same. I also need 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. Please let me know if there is a flaw in my logic as I am not a stats expert. Thanks. Regards Juanette John -- 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

Re: common site for teaching/training materials
by epidata-list＠lists.umanitoba.ca 19 Apr '07

19 Apr '07

AS some of you might have noticed I have already defined an open EpiData site - in the form of a wiki - where some experiences on using this technology already exist. The www.epidata.org site has been reserved by me a few years back with the intention that this could serve as the "community" site for EpiData, maintained collectively by the body of epidata users. Pedro Arias and I created teaching material for use in the Canadian Field Epi course last autumn. Off list I have suggested to a number of users mentioning materials to add these to the site, but the time and energy to get onto a new way of working can be difficult to find for already busy people. If the material already exist it is quite easy to copy and paste into the wiki and upload the figures/images. The experimental site is found at http://www.epidata.org/wiki There is some learning problems in the beginning when editing in the wiki format, but with a few experiments it works very well. An introduction is shown at http://en.wikipedia.org/wiki/Wikipedia:How_to_edit_a_page The optimal would be that a group of persons together take on the responsibility of maintaining the open site, since we must unfortunately expect that someone will add irrelevant material or suggestions which otherwise are not appropriate. The initial steps of forming such a group has been made, but awaits further initiatives. Kind regards Jens Lauritsen -- Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

Re: AW: [EpiData-list] BMI Calculation
by epidata-list＠lists.umanitoba.ca 18 Apr '07

18 Apr '07

Thanks for the link. I was interested to see the Epidata training materials on this site and also the ones now on the Epidata website. I'd be very interested in any other links. I'm especially interested in materials that deal with outbreaks so it was great to see the case study about Tiramisu on the epidata website - but that only deals with the analysis side. (Here we use Epidata for our questionnaires and data entry but use Epi Info for analysis). I've done a training manual for our public health staff about using Epidata and have an outbreak case study exercise that uses epidata and epi info, but have not made on line versions yet. I would be interested in talking to others - perhaps off line about materials they use for epidata training. thanks again Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 >>> <epidata-list(a)lists.umanitoba.ca> 13/04/2007 5:26 p.m. >>> Have a look at the many available documentations on the web. A similar thing (calculating age from date of birth) is included on page 6 of a very useful intro (A brief overview of EpiData software) to be found on http://www.tbrieder.org/ (follow icon to "Revised EpiData course") marcel -----Ursprüngliche Nachricht----- Von: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Gesendet: Donnerstag, 12. April 2007 14:13 An: epidata-list(a)lists.umanitoba.ca Betreff: [EpiData-list] BMI Calculation 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 -- 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 3

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

17 Apr '07

Dear Hans, Your program was quick and efficient. It did it! Thank you for your help. Ali On 4/14/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. BMI from US measures (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 14 Apr 2007 00:25:35 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] BMI from US measures > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <4620035F.20600(a)tbrieder.org> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > If you do not wish to show conversion of US measures into SI units in > the QES file, then your QES file should have this: > > *.QES file > wtpd Weight in US pounds ###.# > htft Height in US feet # > htin Height in US inches ## > bmi Body Mass Index in kg/m^2 ##.# > > You then make all your calculations in the CHK file to get the BMI in SI > units: > > *.CHK file > * Definitions from Wikipedia > * 1 US foot=(1200/3937) meters > * 1 US inch=25.4 millimeters > * 1 US pound= 453.59237 grams > > wtpd > MUSTENTER > END > > htft > MUSTENTER > END > > htin > MUSTENTER > AFTER ENTRY > bmi=(wtpd*0.45359237)/((htft*(1200/3937)+(htin*0.0254))^2) > END > END > > bmi > NOENTER > END > > > and that should do it. Beware of empty fields contributing to the > denominator. Should that be the case, you must make provisions in the > CHK file. The above works only if there are no zeros for the two > denominator variables, and not permitting any blank fields. > > Hans > > -- > Hans L Rieder, MD, MPH > Jetzikofenstr. 12 > 3038 Kirchlindach > Switzerland > > Tel: +41 31 829 4577 > Mob: +41 79 321 9122 > Web: http://www.tbrieder.org > > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 42, Issue 7 > ******************************************* > -- Ali B. Mansaray MANSA Consulting Services 6530 Davidson Road Columbia, SC 29209 803-381-6864 ali.mansaray(a)gmail.com a

1 0

BMI Calculation Suggestions
by epidata-list＠lists.umanitoba.ca 16 Apr '07

16 Apr '07

Thanks ever so much Pedro, Richard and Marcel. I was away and just returned. I am sure your suggestions and insights will amply address my my question. Regards, Ali On 4/13/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. Re: EpiData-list Digest, Vol 42, Issue 5 > (epidata-list(a)lists.umanitoba.ca) > 2. Re: Re: EpiData-list Digest, Vol 42, Issue 5 > (epidata-list(a)lists.umanitoba.ca) > 3. AW: [EpiData-list] BMI Calculation > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 12 Apr 2007 15:39:31 -0300 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] Re: EpiData-list Digest, Vol 42, Issue 5 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: > <a37cfb5a0704121139lba5854ex3941892ba45d43a1(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > 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 > > ******************************************* > > > > > ------------------------------ > > Message: 2 > Date: Thu, 12 Apr 2007 11:56:52 -0700 (PDT) > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Re: EpiData-list Digest, Vol 42, Issue 5 > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <797297.78297.qm(a)web43146.mail.sp1.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > > I useful little trick I picked up for us crazy Americans who insist on > using inches and pounds: Calculate pounds/(height in inches)^2. Multiple > the result by 703.0814 (or however precise you want the result) and you > have BMI. > > Richard Herrell > NIMH > > > epidata-list(a)lists.umanitoba.ca wrote: 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 > > ******************************************* > > > _______________________________________________ > EpiData-list mailing list > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > --------------------------------- > Never miss an email again! > Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out. > > ------------------------------ > > Message: 3 > Date: Fri, 13 Apr 2007 07:26:40 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: AW: [EpiData-list] BMI Calculation > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <96551DCE4DCEF546921A8AF2F60826B0ED10CE(a)mx.ispm.unibe.ch> > Content-Type: text/plain; charset="iso-8859-1" > > Have a look at the many available documentations on the web. > A similar thing (calculating age from date of birth) is included on page 6 > of a very useful intro (A brief overview of EpiData software) to be found on > http://www.tbrieder.org/ (follow icon to "Revised EpiData course") > marcel > > > -----Ursprüngliche Nachricht----- > Von: epidata-list(a)lists.umanitoba.ca [mailto: > epidata-list(a)lists.umanitoba.ca] > Gesendet: Donnerstag, 12. April 2007 14:13 > An: epidata-list(a)lists.umanitoba.ca > Betreff: [EpiData-list] BMI Calculation > > 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 6 > ******************************************* > -- Ali B. Mansaray MANSA Consulting Services 6530 Davidson Road Columbia, SC 29209 803-381-6864 ali.mansaray(a)gmail.com a

1 0

BMI from US measures
by epidata-list＠lists.umanitoba.ca 13 Apr '07

13 Apr '07

If you do not wish to show conversion of US measures into SI units in the QES file, then your QES file should have this: *.QES file wtpd Weight in US pounds ###.# htft Height in US feet # htin Height in US inches ## bmi Body Mass Index in kg/m^2 ##.# You then make all your calculations in the CHK file to get the BMI in SI units: *.CHK file * Definitions from Wikipedia * 1 US foot=(1200/3937) meters * 1 US inch=25.4 millimeters * 1 US pound= 453.59237 grams wtpd MUSTENTER END htft MUSTENTER END htin MUSTENTER AFTER ENTRY bmi=(wtpd*0.45359237)/((htft*(1200/3937)+(htin*0.0254))^2) END END bmi NOENTER END and that should do it. Beware of empty fields contributing to the denominator. Should that be the case, you must make provisions in the CHK file. The above works only if there are no zeros for the two denominator variables, and not permitting any blank fields. Hans -- Hans L Rieder, MD, MPH Jetzikofenstr. 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 321 9122 Web: http://www.tbrieder.org

1 0

BMI Calculation
by epidata-list＠lists.umanitoba.ca 13 Apr '07

13 Apr '07

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

1 1

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