[EpiData-list] PROBLEM: HOW TO CONNECT OVERTIME RECORDS. MESSAGE FOR JAMIE

EpiData development and support epidata-list at lists.umanitoba.ca
Wed Jul 27 00:42:08 CDT 2022


Dear Jamie,

Thank you for your answer but I failed

See below all the commands I tried




Subject: [EpiData-list] PROBLEM:  HOW TO CONNECT OVERTIME RECORDS
          PLEASE
  Message-ID: <20220724052114.e51cdb84 at smail.chu-reunion.fr>
  Content-Type: text/plain;        charset="UTF-8"
  
      

ORIGINAL  QUESTION    


  SAY: you have women all identified by a personal  number
  
  
  When you chose a number, you have all the babies  she had over time
  e.g. a woman had her first child in 2007, the  second one in 2009, the third in 2014 and the last one in 2020
  
  
  If I want to calculate the intervals between  pregnancies (and compare with a risk, preeclampsia for example)
    - What variable should I create?
   - What command should I do to find: in 2009  the interval with the preceding pregnancy was 21 months, in 2014 the interval  with the preceding was 51 months etc....    

     

JAMIE’S ANSWER    

You can do this in Analysis. My  example is for the new EpiData Analysis. Similar commands work in classic  analysis.
  
  First create your time difference variable
  new v mois i; // integer variable called MOIS
  
  Then sort the data by subject ID and delivery date
  sort sujetid accouchment;
  
  Then calculate the time difference between  records, but only when the subject ID is the same as in the previous record
  
  mois := iif(sujetid = sujetid[_n - 1],  (accouchment - accouchment[_n - 1]) DIV 30, 0);
  
  Dividing the delivery dates by 30 gives  approximate months. Dividing by 30.417 and rounding off is more accurate, but  I?d go with the integers.
  
  Jamie    

     

DIEFERENT COMMANDS I TRIED TO DO : ALWAYS « UNKNOWN  IDENTIFYER »    

define interv ###    

let interv = (numero = numero [_ n-1], dn - dn [_n-1]) div  30.41;    

intervl = if (numero = numero [_ n-1], dn - dn [_n-1]) div  30.41;    

interv = iif (numero = numero [_ n-1], dn - dn [_n-1]) div  30.41;    

if (numero = numero [_ n-1] ) then interv = ( dn - dn  [_n-1]) / 30.41;You can do this in Analysis. My example is for the new EpiData Analysis. Similar commands work in classic analysis.

First create your time difference variable
new v mois i; // integer variable called MOIS

Then sort the data by subject ID and delivery date
sort sujetid accouchment;

Then calculate the time difference between records, but only when the subject ID is the same as in the previous record

mois := iif(sujetid = sujetid[_n - 1], (accouchment - accouchment[_n - 1]) DIV 30, 0);

Dividing the delivery dates by 30 gives approximate months. Dividing by 30.417 and rounding off is more accurate, but I?d go with the integers.

Jamie
Dr Pierre-Yves Robillard
Réanimation néonatale et pediatrique, néonatologie
Centre Hospitalier Régional
Groupe Hospitalier Sud-Réunion
BP 350. 97448 Saint-Pierre cedex
Ile de la réunion
  _____  

From: epidata-list-request at lists.umanitoba.ca
To: epidata-list at lists.umanitoba.ca
Sent: Sun, 24 Jul 2022 16:05:18 +0400
Subject: EpiData-list Digest, Vol 206, Issue 1

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. PROBLEM: HOW TO CONNECT OVERTIME RECORDS PLEASE
        (EpiData development and support)
     2. Re: PROBLEM: HOW TO CONNECT OVERTIME RECORDS PLEASE
        (EpiData development and support)
  
  
  ----------------------------------------------------------------------
  
  Message: 1
  Date: Sun, 24 Jul 2022 09:21:14 +0400
  From: EpiData development and support
   <epidata-list at lists.umanitoba.ca>
  To: epidata-list at lists.umanitoba.ca
  Subject: [EpiData-list] PROBLEM: HOW TO CONNECT OVERTIME RECORDS
   PLEASE
  Message-ID: <20220724052114.e51cdb84 at smail.chu-reunion.fr>
  Content-Type: text/plain; charset="UTF-8"
  
  SAY: you have women all identified by a personal number
  
  
  When you chose a number, you have all the babies she had over time
  e.g. a woman had her first child in 2007, the second one in 2009, the third in 2014 and the last one in 2020
  
  
  If I want to calculate the intervals between pregnancies (and compare with a risk, preeclampsia for example)
    - What variable should I create?
   - What command should I do to find: in 2009 the interval with the preceding pregnancy was 21 months, in 2014 the interval with the preceding was 51 months etc....
  
  
  THANK YOU IF CAN HELP
  Best
  
  Dr Pierre-Yves Robillard
  R?animation n?onatale et pediatrique, n?onatologie
  Centre Hospitalier R?gional
  Groupe Hospitalier Sud-R?union
  BP 350. 97448 Saint-Pierre cedex
  Ile de la r?union
    _____  
  
  From: epidata-list-request at lists.umanitoba.ca
  To: epidata-list at lists.umanitoba.ca
  Sent: Mon, 03 Jan 2022 22:00:18 +0400
  Subject: EpiData-list Digest, Vol 202, Issue 1
  
  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. BIG PROBLEMS TO UPDATE A CHK FILE
          (EpiData development and support)
       2. Re: BIG PROBLEMS TO UPDATE A CHK FILE
          (EpiData development and support)
    
    
    ----------------------------------------------------------------------
    
    Message: 1
    Date: Mon, 03 Jan 2022 13:19:13 +0400
    From: EpiData development and support
     <epidata-list at lists.umanitoba.ca>
    To: epidata-list at lists.umanitoba.ca
    Subject: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE
    Message-ID: <20220103091913.c8c2eafa at smail.chu-reunion.fr>
    Content-Type: text/plain; charset="UTF-8"
    
    We are changing year, so I am creating a "RU22.REC" with the root RU21.QES file (to replace the RU21.REC one)
    
    
    1) The other years I went in RU21.CHK and renamed it RU22.CHK and it worked
    When I do this now, I have 3 pages of errors on CHK (which is exactly the same which works with RU21) quite impossible to correct
    
    
    
    
    2) SECOND OPTION: I went on  Epidata analysis and created without any problem RU22.rec Through the procedure
    SAVEDATA c:\data\RU22.REC.  with an automatic transfer of the RU21.CHK to RU22.CHK
    
    
    BUT IT GIVES ME A VERTICAL QUESTIONNAIRE LIKE A VERY LONG SNAKE, VERY BAD TO MAKE A DATA RECORD
    
    
    HOW COULD I THROUGH THE "SAVEDATA" PROCEDURE HAVE AN HORIZONTAL (NORMAL) QUESTIONNAIRE
    
    
    Thank you very much for your help
    
    
    ALSO: HAPPY NEW YEAR
    
    Dr Pierre-Yves Robillard
    R?animation n?onatale et pediatrique, n?onatologie
    Centre Hospitalier R?gional
    Groupe Hospitalier Sud-R?union
    BP 350. 97448 Saint-Pierre cedex
    Ile de la r?union
    
    ------------------------------
    
    Message: 2
    Date: Mon, 3 Jan 2022 08:58:42 -0500
    From: EpiData development and support
     <epidata-list at lists.umanitoba.ca>
    To: EpiData development and support <epidata-list at lists.umanitoba.ca>
    Subject: Re: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE
    Message-ID: <28A45B95-FE40-4966-A975-72FCCD1A533D at bell.net>
    Content-Type: text/plain; charset=us-ascii
    
    Have you tried using the .REC file from 1) with the .CHK file from 2)?
    
    Normally, I would have done pretty much the same as you, but like this:
    
    Use the windows command line to copy files, in this order.
    copy ru21.qes ru22.qes
    Run EpiData to create ru22.rec from ru22.qes
    copy ru21.chk ru22.chk
    
    Jamie
    
    > On Jan 3, 2022, at 4:19 AM, EpiData development and support <epidata-list at lists.umanitoba.ca> wrote:
    > 
    > 1) The other years I went in RU21.CHK and renamed it RU22.CHK and it worked
    > When I do this now, I have 3 pages of errors on CHK (which is exactly the same which works with RU21) quite impossible to correct
    > 
    > 
    > 
    > 
    > 2) SECOND OPTION: I went on  Epidata analysis and created without any problem RU22.rec Through the procedure
    > SAVEDATA c:\data\RU22.REC.  with an automatic transfer of the RU21.CHK to RU22.CHK
    
    
    
    ------------------------------
    
    ________________________________________
    EpiData-list at lists.umanitoba.ca
    http://lists.umanitoba.ca/mailman/listinfo/epidata-list
    
    
    End of EpiData-list Digest, Vol 202, Issue 1
    ********************************************
      
  
  ------------------------------
  
  Message: 2
  Date: Sun, 24 Jul 2022 08:04:29 -0400
  From: EpiData development and support
   <epidata-list at lists.umanitoba.ca>
  To: EpiData development and support <epidata-list at lists.umanitoba.ca>
  Subject: Re: [EpiData-list] PROBLEM: HOW TO CONNECT OVERTIME RECORDS
   PLEASE
  Message-ID: <848EE055-EC37-44A4-87C6-29EBA5918FC9 at bell.net>
  Content-Type: text/plain; charset=utf-8
  
  You can do this in Analysis. My example is for the new EpiData Analysis. Similar commands work in classic analysis.
  
  First create your time difference variable
  new v mois i; // integer variable called MOIS
  
  Then sort the data by subject ID and delivery date
  sort sujetid accouchment;
  
  Then calculate the time difference between records, but only when the subject ID is the same as in the previous record
  
  mois := iif(sujetid = sujetid[_n - 1], (accouchment - accouchment[_n - 1]) DIV 30, 0);
  
  Dividing the delivery dates by 30 gives approximate months. Dividing by 30.417 and rounding off is more accurate, but I?d go with the integers.
  
  Jamie
  
  > 
  > ?SAY: you have women all identified by a personal number
  > 
  > 
  > When you chose a number, you have all the babies she had over time
  > e.g. a woman had her first child in 2007, the second one in 2009, the third in 2014 and the last one in 2020
  > 
  > 
  > If I want to calculate the intervals between pregnancies (and compare with a risk, preeclampsia for example)
  >  - What variable should I create?
  > - What command should I do to find: in 2009 the interval with the preceding pregnancy was 21 months, in 2014 the interval with the preceding was 51 months etc....
  > 
  > 
  > THANK YOU IF CAN HELP
  > Best
  > 
  > Dr Pierre-Yves Robillard
  > R?animation n?onatale et pediatrique, n?onatologie
  > Centre Hospitalier R?gional
  
  
  
  
  ------------------------------
  
  ________________________________________
  EpiData-list at lists.umanitoba.ca
  http://lists.umanitoba.ca/mailman/listinfo/epidata-list
  
  
  End of EpiData-list Digest, Vol 206, Issue 1
  ********************************************
    


More information about the EpiData-list mailing list