March 2008 - EpiData-list - University of Manitoba Mailing Lists

Re: EpiData-list Digest, Vol 53, Issue 3
by epidata-list＠lists.umanitoba.ca 06 Mar '08

06 Mar '08

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

1 0

Re: EpiData-list Digest, Vol 53, Issue 2 - Review Medical records
by epidata-list＠lists.umanitoba.ca 06 Mar '08

06 Mar '08

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 > > >

1 0

CHK file with calculations does not work as it did in EpiInfo
by epidata-list＠lists.umanitoba.ca 06 Mar '08

06 Mar '08

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 __________________________________________________________

1 2

Random selection of records
by epidata-list＠lists.umanitoba.ca 04 Mar '08

04 Mar '08

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

1 1

Complex if statements (was chk file with calculations ....)
by epidata-list＠lists.umanitoba.ca 04 Mar '08

04 Mar '08

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

1 0

Using EpiData to review medical records
by epidata-list＠lists.umanitoba.ca 04 Mar '08

04 Mar '08

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

1 0

Screen Flickering in Epidata data entry
by epidata-list＠lists.umanitoba.ca 04 Mar '08

04 Mar '08

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

1 0