Dear Pedro,
Thank you for your kind reply.
I plan to review medical records using paper form.
Expecting to have 1 observation at baseline to be entered in baseline
file and 6-24 observations for time of follow-up, will be entered in
follow-up file.
Then data will be entered twice and compared (around 600 patients in total).
I am trying to find an alternative way to collect data using papers.
Palm would be solution but more expensive etc..
Thank you in advance and best regards
ziad
On Thu, Mar 6, 2008 at 10:02 AM,
<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 53, Issue 2 - Review Medical
> records (epidata-list(a)lists.umanitoba.ca)
> 2. Re: CHK file with calculations does not work as it did in
> EpiInfo (epidata-list(a)lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 6 Mar 2008 09:13:47 -0300
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Re: EpiData-list Digest, Vol 53, Issue 2 -
> Review Medical records
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID:
> <a37cfb5a0803060413m190e2205jb408707648dbca2a(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear Ziad,
>
> Your question is rather non specific, but I ve been through a similar
> experience with some bad memories.
>
> Review medical records is not an easy task. First of all, the type of study
> > (for exemple a suvival analysis) is of extremem importance on how the data
> > should be organized. Then you must decide what information should be
> > extracted from the records. Going back to the records a second or third time
> > is really frustrating and time consuming. In general for ARV, to register
> > all the ARV combinations, with the start dates and end dates, all CD4 cell
> > counts and Viral loads with their respective dates, all diagnosis of
> > oportunistic infections and their respective dates of diagnosis. Also, you
> > shlould consider making a separate data entry for each one of this data or
> > all of them in the same data entry, if you have someone experience in this
> > tipe of data analyis, the separate way will make easier to extract and type.
> > To use the AUTOSEARCH LIST command in the check file will be of help. Also
> > dont forget a field if the ARV is HAART or not and an outcome such as death
> > and/or hospitalization and of course its date.
> >
>
> Good Luck,
> Pedro Brasil
>
> ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Tue, 4 Mar 2008 10:16:56 -0800
> > From: epidata-list(a)lists.umanitoba.ca
> > Subject: [EpiData-list] Using EpiData to review medical records
> > To: epidata-list(a)lists.umanitoba.ca
> > Message-ID:
> > <897a5cf60803041016y396e0f9dwf0baa18ba3168469(a)mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Dear EpiDataLister,
> > It is semi-technical question. I intend to review medical records
> > retrospectively for patients on ARVs. It seems to be involving lot of
> > papers to review their history to be able to enter them into EpiData.
> > Meant to check if someone had similar experience to share how did you
> > sort it out?
> >
> > Thank you in advance and best regards
> > ziad
> >
> >
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 5 Mar 2008 22:28:28 -0400
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Re: CHK file with calculations does not work
> as it did in EpiInfo
> To: <epidata-list(a)lists.umanitoba.ca>
> Message-ID: <200835222828.983160@IW2575>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Thanks Hans, I don't know what happened. This is what was pasted except that I exchanged the double quotes for single quotes in case that is why text got truncated.
>
> IF N9SUICIDE = 3 or (N9SUICIDE = 2 AND TOTAL >= 16) or TOTAL > 42
> THEN
> ATRISK='Y'
> ELSE
> ATRISK='N'
> ENDIF
> END
>
> John LeBlanc
> -----------------------------------------
> Message: 2
> Date: Tue, 04 Mar 2008 20:10:27 +0100
> From: epidata-list(a)lists.umanitoba.ca
> Subject: Re: [EpiData-list] CHK file with calculations does not work
> as it did in EpiInfo
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID: <47CD9EA3.5000402(a)tbrieder.org>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Unless, something go lost, there is surely something missing here:
>
> IF N9SUICIDE = or (N9SUICIDE = 2 AND TOTAL >= 16) or TOTAL > 42
>
>
> Hans
>
>
> John LeBlanc
>
>
> On Tue, 4 Mar 2008 12:50:55 -0400, John LeBlanc wrote:
> Hi,
>
> I wonder if someone can spot the syntax problem in this CHK file for the Beck Depression inventory. I've struggled for hours to get it to work the way it did under Epi Info. Basically, there are three conditions in an IF statement. I've tried with the two simple conditions alone and the script works (condition at the beginning & at the end). Combining conditions always gives the 'atrisk' calculated variable the answer "N". Is there a limitation or syntax difference in Epidata??
>
> Here's the syntax. thanks for the help.
>
> BEFORE FILE
> DEFINE TOTALPG1 ## GLOBAL
> DEFINE TOTALPG2 ## GLOBAL
> DEFINE varID ####
> END
>
> AFTER RECORD
> TOTALPG1=N1SAD+N2DISCOURA+N3FAILURE+N4SATISFAC+N5GUILT+N6PUNISHED+N7DISAPPOI+N8SELFCRIT+N9SUICIDE+N10CRY+N11IRRITAT
> TOTALPG2=N12INTPPL+N13DECISIO+N14LOOKWOR+N15CANWORK+N16SLEEP+N17TIRED+N18APPETIT+N19WEIGHT+N20WORRYHL+N21INTSEX
> TOTAL=TOTALPG1 + TOTALPG2
> IF N9SUICIDE = 3 or (N9SUICIDE = 2 AND TOTAL >= 16) or TOTAL > 42
> THEN
> ATRISK="Y"
> ELSE
> ATRISK="N"
> ENDIF
> END
>
> idnum
> MUSTENTER
> REPEAT
> AFTER ENTRY
> VarID=IDNUM
> END
> END
>
> total
> NOENTER
> END
>
> atrisk
> NOENTER
> END
>
> n1sad
> RANGE 0 3
> END
>
> etc. for the other variables
>
>
> John LeBlanc
> __________________________________________________________
>
> John C. LeBlanc, MD, MSc, FRCPC
> Associate Professor
> Pediatrics, Psychiatry, Community Health and Epidemiology
> Dalhousie University
>
> IWK Health Centre Work phone: (902) 470-8930
> 5850 University Avenue Work fax: (902) 470-6913
> Halifax, Nova Scotia Email: John.LeBlanc(a)Dal.Ca
> B3K 6R8 CANADA Pager: (902) 470-8888
> __________________________________________________________
>
>
> ------------------------------
>
> ________________________________________
> EpiData-list(a)lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 53, Issue 3
> *******************************************
>
--
Ziad El-Khatib
AIDS Unit
National Institute for Communicable Diseases (NICD)
1 Modderfontein Road
Private Bag X4, Sandringham, 2131
Johannesburg, South Africa
Mobile: +27 (0) 72-52 39 716
Phone: +27 (0) 11-386 6433
Fax (NICD): +27 (0)11 386 6453
Fax (alternative): +27 (0)866 18 2871
http://www.nicd.ac.za/
Division of International Health (IHCAR)
Karolinska Institutet
www.phs.ki.se/ihcar
Dear Ziad,
Your question is rather non specific, but I ve been through a similar
experience with some bad memories.
Review medical records is not an easy task. First of all, the type of study
> (for exemple a suvival analysis) is of extremem importance on how the data
> should be organized. Then you must decide what information should be
> extracted from the records. Going back to the records a second or third time
> is really frustrating and time consuming. In general for ARV, to register
> all the ARV combinations, with the start dates and end dates, all CD4 cell
> counts and Viral loads with their respective dates, all diagnosis of
> oportunistic infections and their respective dates of diagnosis. Also, you
> shlould consider making a separate data entry for each one of this data or
> all of them in the same data entry, if you have someone experience in this
> tipe of data analyis, the separate way will make easier to extract and type.
> To use the AUTOSEARCH LIST command in the check file will be of help. Also
> dont forget a field if the ARV is HAART or not and an outcome such as death
> and/or hospitalization and of course its date.
>
Good Luck,
Pedro Brasil
----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 4 Mar 2008 10:16:56 -0800
> From: epidata-list(a)lists.umanitoba.ca
> Subject: [EpiData-list] Using EpiData to review medical records
> To: epidata-list(a)lists.umanitoba.ca
> Message-ID:
> <897a5cf60803041016y396e0f9dwf0baa18ba3168469(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Dear EpiDataLister,
> It is semi-technical question. I intend to review medical records
> retrospectively for patients on ARVs. It seems to be involving lot of
> papers to review their history to be able to enter them into EpiData.
> Meant to check if someone had similar experience to share how did you
> sort it out?
>
> Thank you in advance and best regards
> ziad
>
>
>
Hi,
I wonder if someone can spot the syntax problem in this CHK file for the Beck Depression inventory. I've struggled for hours to get it to work the way it did under Epi Info. Basically, there are three conditions in an IF statement. I've tried with the two simple conditions alone and the script works (condition at the beginning & at the end). Combining conditions always gives the 'atrisk' calculated variable the answer "N". Is there a limitation or syntax difference in Epidata??
Here's the syntax. thanks for the help.
BEFORE FILE
DEFINE TOTALPG1 ## GLOBAL
DEFINE TOTALPG2 ## GLOBAL
DEFINE varID ####
END
AFTER RECORD
TOTALPG1=N1SAD+N2DISCOURA+N3FAILURE+N4SATISFAC+N5GUILT+N6PUNISHED+N7DISAPPOI+N8SELFCRIT+N9SUICIDE+N10CRY+N11IRRITAT
TOTALPG2=N12INTPPL+N13DECISIO+N14LOOKWOR+N15CANWORK+N16SLEEP+N17TIRED+N18APPETIT+N19WEIGHT+N20WORRYHL+N21INTSEX
TOTAL=TOTALPG1 + TOTALPG2
IF N9SUICIDE = 3 or (N9SUICIDE = 2 AND TOTAL >= 16) or TOTAL > 42
THEN
ATRISK="Y"
ELSE
ATRISK="N"
ENDIF
END
idnum
MUSTENTER
REPEAT
AFTER ENTRY
VarID=IDNUM
END
END
total
NOENTER
END
atrisk
NOENTER
END
n1sad
RANGE 0 3
END
etc. for the other variables
John LeBlanc
__________________________________________________________
John C. LeBlanc, MD, MSc, FRCPC
Associate Professor
Pediatrics, Psychiatry, Community Health and Epidemiology
Dalhousie University
IWK Health Centre Work phone: (902) 470-8930
5850 University Avenue Work fax: (902) 470-6913
Halifax, Nova Scotia Email: John.LeBlanc(a)Dal.Ca
B3K 6R8 CANADA Pager: (902) 470-8888
__________________________________________________________
Dear Jamie,
Thank you so much for the solution for the query INCOMPATIBLE KEY VARIABLES. It worked well.
Can you please help in two other situation also ?
1. There is a file say try.rec Is it possible to read it and write another file with 5 randomly selected records or selecting every 4th record (as done in systematic sampling). The documentation of the commands such as SET RANDOM SEED and RANDOM SIMULATIONS is not clear in the help file. I am attaching a sample file try.zip.
2.What is the equivalent of SET LISTREC=ON/OFF (EPI6) in Epi Analysis ver 2.03 ?
With regards,
Dr. Shavinder Singh
For the suggested chk file command:
> IF N9SUICIDE = 3 or (N9SUICIDE = 2 AND TOTAL >= 16) or TOTAL > 42
> THEN
> ATRISK="Y"
> ELSE
> ATRISK="N"
> ENDIF
>
I would always write:
IF ((N9SUICIDE = 3) or ((N9SUICIDE = 2) AND (TOTAL >= 16)) or (TOTAL > 42)) then
most likely this would/should also work:
IF (N9SUICIDE = 3) or ((N9SUICIDE = 2) AND (TOTAL >= 16)) or (TOTAL > 42) then
In other words: Always be very explicit with parenthesis.
Test and report please.
regards
Jens Lauritsen
EpiData Association
Dear EpiDataLister,
It is semi-technical question. I intend to review medical records
retrospectively for patients on ARVs. It seems to be involving lot of
papers to review their history to be able to enter them into EpiData.
Meant to check if someone had similar experience to share how did you
sort it out?
Thank you in advance and best regards
ziad
I'm using epidata on thinkpad winXP sp2 laptop- all drivers are updated:
One "bug" which is very annoying is that the whole screen output
constantly flickers and is unstable when I enter data. It seems like
the whole screen sort of disappears with every key that is pressed.
This bug is only present in the data entry form
Is this something which can be prevented??
thanks
--
Jannik