EpiData-list

Download

epidata-list@lists.umanitoba.ca

July 2022

1 participants
2 discussions

PROBLEM: HOW TO CONNECT OVERTIME RECORDS. MESSAGE FOR JAMIE
by EpiData development and support 27 Jul '22

27 Jul '22

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(a)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(a)lists.umanitoba.ca To: epidata-list(a)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(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. 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(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] PROBLEM: HOW TO CONNECT OVERTIME RECORDS PLEASE Message-ID: <20220724052114.e51cdb84(a)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(a)lists.umanitoba.ca To: epidata-list(a)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(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. 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(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE Message-ID: <20220103091913.c8c2eafa(a)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(a)lists.umanitoba.ca> To: EpiData development and support <epidata-list(a)lists.umanitoba.ca> Subject: Re: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE Message-ID: <28A45B95-FE40-4966-A975-72FCCD1A533D(a)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(a)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(a)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(a)lists.umanitoba.ca> To: EpiData development and support <epidata-list(a)lists.umanitoba.ca> Subject: Re: [EpiData-list] PROBLEM: HOW TO CONNECT OVERTIME RECORDS PLEASE Message-ID: <848EE055-EC37-44A4-87C6-29EBA5918FC9(a)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(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 206, Issue 1 ********************************************

1 1

PROBLEM: HOW TO CONNECT OVERTIME RECORDS PLEASE
by EpiData development and support 24 Jul '22

24 Jul '22

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(a)lists.umanitoba.ca To: epidata-list(a)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(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. 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(a)lists.umanitoba.ca> To: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE Message-ID: <20220103091913.c8c2eafa(a)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(a)lists.umanitoba.ca> To: EpiData development and support <epidata-list(a)lists.umanitoba.ca> Subject: Re: [EpiData-list] BIG PROBLEMS TO UPDATE A CHK FILE Message-ID: <28A45B95-FE40-4966-A975-72FCCD1A533D(a)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(a)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(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 202, Issue 1 ********************************************

1 1