[EpiData-list] Re: EpiData-list Digest, Vol 40, Issue 15

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Wed Feb 21 11:32:56 CST 2007


Dear Shavinder Singh,

I did learn in the same as you, missing a lot first. Dont give up. My
suggestion is to put this variable on the .QES that would be automatically
calculate during entry.

Usually the formula is  LET variable_age=ROUND(INT((now_date -
birth_date)/365.25))

Epidata does not round and transform the calculation automatically and this
syntax is necessary every time you will do any calculation with dates.

Good luck,
Pedro Emmanuel Brasil



2007/2/20, epidata-list-request at lists.umanitoba.ca <
epidata-list-request at lists.umanitoba.ca>:
>
> Send EpiData-list mailing list submissions to
>         epidata-list at 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 at lists.umanitoba.ca
>
> You can reach the person managing the list at
>         epidata-list-owner at 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. Date range selection for age calculation
>       (epidata-list at lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: 20 Feb 2007 07:15:30 -0000
> From: epidata-list at lists.umanitoba.ca
> Subject: [EpiData-list] Date range selection for age calculation
> To: epidata-list-request at lists.umanitoba.ca
> Cc: epidata-list at lists.umanitoba.ca
> Message-ID: <20070220071530.19938.qmail at webmail35.rediffmail.com>
> Content-Type: text/plain;       charset=iso-8859-1
>
> Dear Epidata team friends,
>                                               I have two American date
> format variables. DOB is date of birth of baby and WDATE is date of weighing
> the baby for the growth monitoring.
>
> I used to write the following statement to calculate the age in months in
> EPI6
>
> Define age ###
> Let age=(WDATE – DOB)/30.44
>
> That does not work in EPI ANALYSIS
>
> I tried the statement;
> Let age= (date("WDATE","mdy") - date("DOB","mdy"))/30.44
> The error message was;
> Data type mismatch
>
> Please help.
>
> Shavinder Singh
>
>
>
> ------------------------------
>
> ________________________________________
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 40, Issue 15
> ********************************************
>



-- 
Abraço forte e que a força esteja com você,
Pedro Emmanuel


More information about the EpiData-list mailing list