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
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
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
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
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
> *******************************************
>
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.
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.
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 **
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
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