- EpiData-list - University of Manitoba Mailing Lists

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

Re: DEFINE var not seen in file structure
by epidata-list＠lists.umanitoba.ca 28 Feb '08

28 Feb '08

Thank you Jens. This is most helpful. Sorry for not replying sooner, had problems with getting connected to the net. I will revise the QES and CHK file accordingly and come back if there are further issues. Again, Many thanks Kindest Regards SK -----Original Message----- From: epidata-list-request(a)lists.umanitoba.ca To: epidata-list(a)lists.umanitoba.ca Sent: Sun, 24 Feb 2008 8:04 pm Subject: EpiData-list Digest, Vol 52, Issue 12 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. DEFINE var not seen in file structure. Answer: Define in entry and in analysis have different consequences (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: Sun, 24 Feb 2008 11:04:40 +0100 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] DEFINE var not seen in file structure. Answer: Define in entry and in analysis have different consequences To: epidata-list(a)lists.umanitoba.ca Message-ID: <47C14138.2070103(a)epidata.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed There are two types of variables: 1. Variables which can be saved in files. In Entry these are defined in the qes file, e.g. var1 Label for this variable #### After creating the data file (rec file) and entering data, the data are stored in a rec file In Analysis variables can be created in two ways: a. Define var1 ###### var1 = integer((today-dob)/365.25) label var1 "Age at date of calculation" b gen i var1 = integer((today-dob)/365.25) label var1 "Age at date of calculation" c In both instances (a+b) the values are only kept further on if you issue a saving command: savedata 2. Temporary variables - which are only kept in memory In entry these are defined as SK did: > BEFORE FILE > DEFINE var1 ##### > DEFINE var2 ##### > END In analysis these are defined : (notice "global") define var1 ##### global Temporary variables cannot be saved to a rec file unless the content is transferred to a variable saved in a data file. Sometimes we call variables in data files for "fields" in contrast to what is only in memory. SK could argue that define should do the same in analysis and entry to avoid the confusion. In other words now SK can get the results of the calculation saved for analysis by: Add to the qes file aged Age in days ##### agem Age in months #### chk file. remove the "define" in before file but keep the calculation "let" in the "after entry" block and add this aged noenter end agem noenter end regards Jens Lauritsen EpiData Association ------------------------------ ________________________________________ EpiData-list(a)lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list End of EpiData-list Digest, Vol 52, Issue 12 ********************************************

1 0

RE: EpiData-list Digest, Vol 52, Issue 13
by epidata-list＠lists.umanitoba.ca 27 Feb '08

27 Feb '08

Merci beacoup - I realised that obvious solution just after I posted the question!! Sorry! Dr Josh Davis NH&MRC Scholar Menzies School of Health Research Staff Specialist in Infectious Diseases and General Medicine Royal Darwin Hospital -----Original Message----- From: epidata-list-bounces(a)lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list-request(a)lists.umanitoba.ca Sent: Thursday, 28 February 2008 3:43 AM To: epidata-list(a)lists.umanitoba.ca Subject: EpiData-list Digest, Vol 52, Issue 13 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. Incompatible Key Variables (epidata-list(a)lists.umanitoba.ca) 2. Problem with label values (epidata-list(a)lists.umanitoba.ca) 3. Re: Incompatible Key Variables (epidata-list(a)lists.umanitoba.ca) 4. Re: Problem with label values (epidata-list(a)lists.umanitoba.ca) ---------------------------------------------------------------------- Message: 1 Date: 27 Feb 2008 06:38:27 -0000 From: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Incompatible Key Variables To: epidata-list-request(a)lists.umanitoba.ca Cc: epidata-list(a)lists.umanitoba.ca Message-ID: <20080227063827.17613.qmail(a)webmail47.rediffmail.com> Content-Type: text/plain; charset="iso-8859-1" Dear Epidata users, I am trying to relate a child file (gm.rec which is growth monitoring data) with the parent file (Under5b.rec, an under 5 children file) The card variable of Under5b.rec is <IDNUM> type while it is numeric in the GM.rec file. After giving the MERGE CARD /FILE=UNDER5B.REC command, I get the following message; Incompatible key variables. Current file: Card of type Float Merge file: Card of type Integer Is there any solution for this problem. Actually IDNUM (automatic counter) is also a numeric variable. EPI6 relates these without any problem. Can any one help please. I am attaching a child.zip file (Under5b.rec and gm.rec in the form of child.zip) for the demonstration of the problem. Waiting for you response. With regards Dr. Shavinder SinghÂ

1 0

Problem with label values
by epidata-list＠lists.umanitoba.ca 27 Feb '08

27 Feb '08

I have several list fields in my datasheet which have more than 9 possible values, and I want to make a label list reflecting this. However. Epidata seems to only allow up to 9. I can;t find documentation on this, but trial and error tells me. Are there any possible solutions? (to clarify, I have: LABEL label_resid 1 abc 2 ddd 3 kk 4 ggg (and then up to 12, and 99 for unknown) 99 unknown END Dr Josh Davis NH&MRC PhD Scholar Menzies School of Health Research and Charles Darwin University Darwin, NT Staff Specialist in Infectious Diseases and General Medicine Royal Darwin Hospital ________________________________

1 1

Incompatible Key Variables
by epidata-list＠lists.umanitoba.ca 27 Feb '08

27 Feb '08

Dear Epidata users, I am trying to relate a child file (gm.rec which is growth monitoring data) with the parent file (Under5b.rec, an under 5 children file) The card variable of Under5b.rec is <IDNUM> type while it is numeric in the GM.rec file. After giving the MERGE CARD /FILE=UNDER5B.REC command, I get the following message; Incompatible key variables. Current file: Card of type Float Merge file: Card of type Integer Is there any solution for this problem. Actually IDNUM (automatic counter) is also a numeric variable. EPI6 relates these without any problem. Can any one help please. I am attaching a child.zip file (Under5b.rec and gm.rec in the form of child.zip) for the demonstration of the problem. Waiting for you response. With regards Dr. Shavinder Singh

1 1

DEFINE var not seen in file structure. Answer: Define in entry and in analysis have different consequences
by epidata-list＠lists.umanitoba.ca 24 Feb '08

24 Feb '08

There are two types of variables: 1. Variables which can be saved in files. In Entry these are defined in the qes file, e.g. var1 Label for this variable #### After creating the data file (rec file) and entering data, the data are stored in a rec file In Analysis variables can be created in two ways: a. Define var1 ###### var1 = integer((today-dob)/365.25) label var1 "Age at date of calculation" b gen i var1 = integer((today-dob)/365.25) label var1 "Age at date of calculation" c In both instances (a+b) the values are only kept further on if you issue a saving command: savedata 2. Temporary variables - which are only kept in memory In entry these are defined as SK did: > BEFORE FILE > DEFINE var1 ##### > DEFINE var2 ##### > END In analysis these are defined : (notice "global") define var1 ##### global Temporary variables cannot be saved to a rec file unless the content is transferred to a variable saved in a data file. Sometimes we call variables in data files for "fields" in contrast to what is only in memory. SK could argue that define should do the same in analysis and entry to avoid the confusion. In other words now SK can get the results of the calculation saved for analysis by: Add to the qes file aged Age in days ##### agem Age in months #### chk file. remove the "define" in before file but keep the calculation "let" in the "after entry" block and add this aged noenter end agem noenter end regards Jens Lauritsen EpiData Association

1 0