Re : EpiData-list Digest, Vol 37, Issue 8

28 Nov 2006


      Bonjour,
Merci de ne plus m'envoyer de messages!!!
Cordialement
----- Message d'origine ----
De : "epidata-list-request@lists.umanitoba.ca" epidata-list-request@lists.umanitoba.ca
À : epidata-list@lists.umanitoba.ca
Envoyé le : Mardi, 28 Novembre 2006, 19h07mn 30s
Objet : EpiData-list Digest, Vol 37, Issue 8
Send EpiData-list mailing list submissions to
    epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at
    epidata-list-owner@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. relational databases- using a mother file field in a check
      for a child file field (epidata-list@lists.umanitoba.ca)
   2. Re: relational databases- using a mother file field in    a
      check for a child file field (epidata-list@lists.umanitoba.ca)
   3. Re: Value Label (epidata-list@lists.umanitoba.ca)
   4. Re: relational databases- using a mother file field    in a
      check for a child file field (epidata-list@lists.umanitoba.ca)
   5. relational databases- using a mother file field    in     a check
      for a child file field (epidata-list@lists.umanitoba.ca)
----------------------------------------------------------------------
Message: 1
Date: Mon, 27 Nov 2006 16:54:24 +1100
From: epidata-list@lists.umanitoba.ca
Subject: [EpiData-list] relational databases- using a mother file
    field in a check for a child file field
To: epidata-list@lists.umanitoba.ca
Message-ID: 5.1.0.14.2.20061127165249.018c76c8@mail.mcri.edu.au
Content-Type: text/plain; charset="us-ascii"; format=flowed
Dear listers,
I have created a relational EpiData database where the value of a field 
called RECDATE is automatically passed from the mother file to the related 
child file. This works fine. I have a field in the child file called DATE 
and wish to ensure that DATE is always later than RECDATE. I have tried the 
following check:
date
   AFTER ENTRY
     IF DATE< RECDATE THEN
       HELP "The date can't be earlier than the date of recruitment" TYPE=ERROR
     ENDIF
   END
END
And I get the following error:
Error in IF expression: Invalid parameters to DATE.
Does anyone have any advice on using automatically passed variables in 
checks? All help is much appreciated. In case it helps, here is the start 
of my child.chk file.
BEFORE RECORD
   RECDATE=varRECDATE
END
id
   KEY 1
END
recdate
   NOENTER
END
date
   RANGE 1/1/2006 31/12/2007
   LEGAL
     1/1/1800
     1/1/1900
   END
   AFTER ENTRY
     IF DATE< RECDATE THEN
       HELP "The date can't be earlier than the date of recruitment" TYPE=ERROR
     ENDIF
   END
END
Katherine Smith
Research Assistant
Clinical Epidemiology and Biostatistics Unit (CEBU)
Murdoch Childrens Research Institute
(03) 9345 7957
katherine.smith@mcri.edu.au
------------------------------
Message: 2
Date: Tue, 28 Nov 2006 12:08:49 +1100
From: epidata-list@lists.umanitoba.ca
Subject: Re: [EpiData-list] relational databases- using a mother file
    field in    a check for a child file field
To: "epidata-list@lists.umanitoba.ca"
    epidata-list@lists.umanitoba.ca
Message-ID:
    525bc0510611271708q5b0863c8x25ba004ddd750fc0@mail.gmail.com
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi Katherine,
I have just had a similar problem - it seems to be with using the word
"date" which is reserved as a function in Epidata. I don't know how to get
around this (maybe someone else here does) so for my database I simply
changed the name of the variable to something else (e.g. vdate).
Charity
On 11/27/06, epidata-list@lists.umanitoba.ca <
epidata-list@lists.umanitoba.ca> wrote:
...
And I get the following error:
Error in IF expression: Invalid parameters to DATE.
------------------------------
Message: 3
Date: Mon, 27 Nov 2006 17:52:12 -0500
From: epidata-list@lists.umanitoba.ca
Subject: Re: [EpiData-list] Value Label
To: epidata-list@lists.umanitoba.ca
Message-ID: 456B6C1C.90103@sympatico.ca
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
You could just recode q05 to a text variable:
define modq05 __________
recode q05 to modq05 lo-2.0 = "Anaemia" 12.0-hi = "Hb Normale"
When you do this, check to see where a value of exactly 12 is 
classified. If in the wrong category, then use
recode q05 to modq05 12.0-hi = "Hb Normale" lo-12.0 = "Anaemia"
That is, the final a-b=c is the one that counts for points at your 
dividing point between categories.
In the latest (test) release of Analysis, you can add variable name and 
value labels, but this feature is not yet documented.
Jamie
Jean-Paul wrote:
...
Hello to All,
I would like to give names to dichotomisées variables. 
By example: I dichotomise the variable Q05 (Rate of Haemoglobin) in two cathégories; modQ05 (Class of Hb) 1=TxHb < 12 mg / dl, 2=TxHb > 12 mg / dl.
Afterward, I would like to call 1 = "Anaemia 2" = "Hb Normale".
So that when I make Freq modQ05, I obtain the distribution by looking directly
Anaemia
Hb Normal
------------------------------
Message: 4
Date: Mon, 27 Nov 2006 17:29:21 -0500
From: epidata-list@lists.umanitoba.ca
Subject: Re: [EpiData-list] relational databases- using a mother file
    field    in a check for a child file field
To: epidata-list@lists.umanitoba.ca
Message-ID: 456B66C1.10406@sympatico.ca
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Do not make a variable with the name DATE. DATE is an EpiData function 
name. The general rule is that you should never create a variable with 
the same name as is used anywhere in EpiData's syntax. Change the 
variable name to DxDate or RxData or IntervDate.
Jamie
Katherine wrote:
...
Dear listers,
I have created a relational EpiData database where the value of a 
field called RECDATE is automatically passed from the mother file to 
the related child file. This works fine. I have a field in the child 
file called DATE and wish to ensure that DATE is always later than 
RECDATE. I have tried the following check:
date
  AFTER ENTRY
    IF DATE< RECDATE THEN
      HELP "The date can't be earlier than the date of recruitment" 
TYPE=ERROR
    ENDIF
  END
END
------------------------------
Message: 5
Date: Tue, 28 Nov 2006 15:31:00 +1100
From: epidata-list@lists.umanitoba.ca
Subject: [EpiData-list] relational databases- using a mother file
    field    in     a check for a child file field
To: epidata-list@lists.umanitoba.ca
Message-ID: 5.1.0.14.2.20061128152929.00c4f020@mail.mcri.edu.au
Content-Type: text/plain; charset="us-ascii"; format=flowed
Dear Jamie and Charity,
Thank you very much for your prompt replies. Changing the name of the field 
to something other than DATE solved the problem.
Best wishes,
Katherine
Katherine Smith
Research Assistant
Clinical Epidemiology and Biostatistics Unit (CEBU)
Murdoch Childrens Research Institute
(03) 9345 7957
katherine.smith@mcri.edu.au
------------------------------
________________________________________
EpiData-list@lists.umanitoba.ca
http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 37, Issue 8
*******************************************
___________________________________________________________________________ 
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

epidata-list＠lists.umanitoba.ca

tags (0)

participants (1)