August 2007 - EpiData-list - University of Manitoba Mailing Lists

New test build 118 for EpiData Analysis
by epidata-list＠lists.umanitoba.ca 31 Aug '07

31 Aug '07

Yesterday I uploaded a new test build for analysis, now build 118. Since previous test build many internal parts have been rewritten, such that the source code is the same where possible for analysis, entry and epic. Most of this is invisible to the end-user, but assures that e.g. chk files are read the same way in the systems. A few aspects remain btw. the products. e.g. naming of integer function int() versus integer(). Of particular interest to the end-user is the following: Practical: a. A new table dialog makes it easier (hopefully) to use the possibilities in the new table command without using the command prompt. The table dialog is available from the toolbar or as a command tabdialog. b. Graphs can now be made by a group variable. e.g. box age /by=sex will create two boxes for two values of sex c CHK files are now saved with the data. Including definitions of variable labels and missing values. d When looking at a table or graph in output, rightclicking with the mouse copies that table or graph to clipboard. (for tables sometimes there is a pointer error, but this will be fixed). Technical issues: a. No new functionality will be added before release as public v2.0 except for translation, which is about half way implemented. b. Bugs should be removed before releasing. - some issues are known and will be documented in the Mantis database c. We should decide what to do about text strings in rec files, which are found in the qes files, but not read into analysis. d. Translation for analysis is about half way e. the Mantis system is not completely updated, but this should take place within about a week to reflect what was fixed and what remains. f. There are still some minor estimation problems, such as percentiles not being correct with very small samples (e.g. n<15). Regards to all -- Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

Re: [EpiData-list] Re: Ranked variable questions
by epidata-list＠lists.umanitoba.ca 26 Aug '07

26 Aug '07

You are right Jamie - a response of 1 was given for most imporant. I will try using your v1=10-v1 and then the method Jens suggests. thank you very much to both you and Jens for your help Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 >>> <epidata-list(a)lists.umanitoba.ca> 24/08/2007 1:33 p.m. >>> An important question is whether a response of 1 most important or least important? If 1 is most important, then make the default value 11 and not zero. I would just do: describe v1-v25 and scan the medians to find those with the lowest median (if 1 is most important and default is 11) or highest median (10 is most important and default is 0). Items that are infrequently ranked will have a median equal to the default. Items most frequently ranked will have a median that is based mostly on ranks. I haven't thought about the formal statistical analysis here, but you'll get a pretty good assessment. Jens approach works very well when the most important response is 10. If most important is 1, then you can also do this: v1 = 10-v1 v2 = 10- v2 etc and use aggregate. jamie > Christine wrote: > I have been asked to set up a database for a questionnaire that has > already been written. I was going to set it up in epidata but my > problem is how to deal witha question that asks people to rank > options. The question gives a list of topics and asks the person > filling in the questionnaire to rank them from 1-10 in order of > importance. > Jens wrote: > I suggest to do the following: > For each question (say 25 different themes) enter the priority the > person gave to that issue. > setup the qes: > v1 item1 ..... ## > v2 item2 ..... ## > etc > v25 text for item 25 ## > > in chk make the defaultvalue 0: > before file > DEFAULTVALUE v1-v25 0 > end > > Then in analysis after entering the data: (say you had the 25 variables) > read response > aggregate /sum="v1,v2,v3,v4,v5" > aggregate /sum="v6,v7,v8,v9,v10" etc > > * the tables will show the sum of the variables, that is the overall > ranking sum. > -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 0

Alyshia Landry is out of the office.
by epidata-list＠lists.umanitoba.ca 24 Aug '07

24 Aug '07

I will be out of the office starting 08/24/2007 and will not return until 08/28/2007. If you require immediate assistance, please contact Stephen Drew at extension 5330.

1 0

Re: Ranked variable questions
by epidata-list＠lists.umanitoba.ca 23 Aug '07

23 Aug '07

Christine wrote: I have been asked to set up a database for a questionnaire that has already been written. I was going to set it up in epidata but my problem is how to deal witha question that asks people to rank options. The question gives a list of topics and asks the person filling in the questionnaire to rank them from 1-10 in order of importance. I suggest to do the following: For each question (say 25 different themes) enter the priority the person gave to that issue. setup the qes: v1 item1 ..... ## v2 item2 ..... ## etc v25 text for item 25 ## in chk make the defaultvalue 0: before file DEFAULTVALUE v1-v25 0 end Then in analysis after entering the data: (say you had the 25 variables) read response aggregate /sum="v1,v2,v3,v4,v5" aggregate /sum="v6,v7,v8,v9,v10" etc * the tables will show the sum of the variables, that is the overall ranking sum. example read bromar // example data set for epidata aggregate /sum="dectime,km,age" which gives the output: N Ndectime SUMdecti1 Nkm SUMkm Nage SUMage 4027 3556 13913.85 3620 381084.00 3786 153740 telling us: 4027 observations in all of these 3556 contributed to dectime, 3620 to km and 3786 to age variables. Sum of the three being 13913.85, 381084.00 and 153740 Obviously here the sum makes no sense, but in your case the sum of the ranking would reflect all of the variables and the responses. regards Jens Lauritsen EpiData Association ps. I tried to locate the user sending spam to the list today/yesterday and may effectively have deleted this person from the list (if not we will see more of the same spam) - terribly annoying.

1 1

Réponse automatique d'absence du bureau : [EpiData-list] FW: Fw: Fw: Doorst.: FW: Read & Respond
by epidata-list＠lists.umanitoba.ca 23 Aug '07

23 Aug '07

Bonjour, Je suis actuellement absent du bureau.Je serai de retour le 3 septembre 2007 Je répondrai à cette date à votre message A bientôt Hello, I am currently out of the office and will be back on September the 3rd, 2007 I will reply to your message then. All the best Robert

1 0

FW: Fw: Fw: Doorst.: FW: Read & Respond
by epidata-list＠lists.umanitoba.ca 23 Aug '07

23 Aug '07

> -----Ursprüngliche Nachricht----- > Von: "B. Wiedemann" <x-72(a)gmx.de> > Gesendet: 23.08.07 09:24:18 > An: christopher.bohn2(a)travedsl.de, ilsa.ramm(a)gmx.de, b-loewe(a)web.de, m.siebelts(a)email.de, lottaleben(a)atomstromfrei.de > Betreff: Fwd: Fw: Fw: Doorst.: FW: Read & Respond -------- Original-Nachricht -------- > Datum: Thu, 16 Aug 2007 07:49:53 +0200 > Von: "Jochen Fölsterprivat" <jochen.foelster(a)foefi.de> > An: "Yvonne Moutoux" <Moutoux(a)gmx.de>, "tina johanssen" <tina_johanssen(a)yahoo.de>, "michelle" <michelle.sachs(a)gmx.net>, "Beate x-72" <x-72(a)gmx.de>, "Aljonna" <aljonna(a)foefi.de>, "aareinhild" <reinhild.fragel(a)foefi.de> > Betreff: Fw: Fw: Doorst.: FW: Read & Respond > ----- Original Message ----- From: <Grunigrunewald(a)aol.com> > To: <airoff2(a)ham.airport.de>; <Almuth.Hanke(a)gmx.de>; <McClouds(a)Collie.de>; > <chengizkaan2004(a)hotmail.com>; <Doris.Steiner(a)sparkasse-stormarn.de>; > <jochen.foelster(a)foefi.de>; <Katfoel(a)aol.com>; <knebel(a)esenet.dk>; > <mail(a)jenskohnert.de>; <koschoe(a)de.ibm.com> > Sent: Wednesday, August 15, 2007 10:51 PM > Subject: Fwd: Fw: Doorst.: FW: Read & Respond > > > > > > > > > > > > > -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. > Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail > > ----------------------------------------------------------------- > > > > ----- Original Message ----- > From: esther > > To: Dirk Huizinga > > Cc: frank ; ilonka ; Jacquie Smilde ; karolina bonefaas ; Peter ; Sandra Koegler-Lieshout ; W.G. Schönhage > > Sent: Wednesday, August 15, 2007 12:42 PM > > Subject: Doorst.: FW: Read & Respond > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Read this...I mean REALLY read this > > > > > > > > > > This is without a doubt one of the nicest good luck forwards I have received. Hope it works for you -- and me! > > > You have 6 minutes > > > There's some mighty fine advice in these words, even if you're not superstitious. This has been sent To you for good luck from the Anthony Robbins organization. It has been sent around the world ten times so Far. > > > Do not keep this message. > > > This must leave your hands in 6 MINUTES. Otherwise you will get a very unpleasant surprise. This is true, even if you are not superstitious, agnostic, or otherwise faith impaired. > > > > > > > ONE. > > > Give people more than they expect and do it cheerfully. > > > TWO > > > . Marry a man/woman you love to talk to. As you get older, their conversational skills will be as important as any other. > > > THREE. > > > Don't believe all you hear, spend all you have or sleep all you want. > > > FOUR > > > . When you say, "I love you ," mean it. > > > FIVE. > > > When you say, "I'm sorry," look the person in the eye. > > > SIX > > > . Be engaged at least six months before you get married. > > > SEVEN. > > > Believe in love at first sight. > > > EIGHT. > > > Never laugh at anyone's dream. People who don't have dreams don't have much. > > > NINE > > > . Love deeply and passionately. You might get hurt but it's the only way to live life completely. > > > TEN. > > > . In disagreements, fight fairly. No name calling. > > > ELEVEN > > > . Don't judge people by their relatives. > > > TWELVE. > > > Talk slowly but think quickly. > > > THIRTEEN > > > . When someone asks you a question you don't want to answer, smile and ask, "Why do you want to know?" > > > FOURTEEN > > > . Remember that great love and great achievements involve great risk. > > > > FIFTEEN. > > > Say "bless you" when you hear someone sneeze. > > > > SIXTEEN > > > . When you lose, don't lose the lesson ! > > > SEVENTEEN > > > . Remember the three R's: Respect for self; Respect for others; and responsibility for all your actions. > > > EIGHTEEN. > > > Don't let a little dispute injure a great friendship. > > > NINETEEN. > > > When you realize you've made a mistake, take immediate steps to correct it. > > > TWENTY. > > > Smile when picking up the phone. The caller will hear it in your voice > > > > TWENTY-ONE. > > > Spend some time alone. > > > > Now, here's the FUN part! > > > Send this to at least 5 people and your life will improve. 1-4 people: Your life will improve slightly. > > > 5-9 people: Your life will improve to your liking. > > > 9-14 people: You will have at least 5 surprises in the next 3 weeks > > > 15 and above: Your life will improve drastically and everything you ever dreamed of will begin to take shape. > > > A true friend is someone who reaches for your hand and touches your heart. Do not keep this message > > > > > > ********************************************************************************************************* > > > > > > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.11/944 - Release Date: 9/08/2007 2:44 p.m. > > > ----------------------------------------------------------------- > Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it! > > > > > > > > > > > > > > > > > > > > >

1 0

Ranked variable questions
by epidata-list＠lists.umanitoba.ca 23 Aug '07

23 Aug '07

Hello everyone I have been asked to set up a database for a questionnaire that has already been written. I was going to set it up in epidata but my problem is how to deal with a question that asks people to rank options. The question gives a list of topics and asks the person filling in the questionnaire to rank them from 1-10 in order of importance. (It is for a city council and they want to know what young people are most concernred about so the choices are crime, employment, environment etc). I thought in the qes I could just make a variable for each topic and enter the number the respondent puts beside it, but I don't know how to then analyse the answers, so I can find out what the top 10 issues are overall. If anyone has done this before and can offer a suggestion I would be grateful thanks Christine Christine Roseveare Analyst Regional Public Health 570 9194 027 495 9671 -- The information contained in this email and any attachments is confidential and may be legally privileged. If you have received this message in error, please notify the sender immediately and remove all copies of the message, including any attachments. Any views or opinions expressed in this email (unless otherwise stated) may not represent those of Hutt Valley DHB. Thank you. ** Disclaimer added by HVDHB **

1 0

Re: Incomplete execution of PGM due to no observations in a select
by epidata-list＠lists.umanitoba.ca 20 Aug '07

20 Aug '07

Just add "IMIF" in each select group: (here shown with one group): TYPE "\LTABLE SHOWING ILLNESS IN THE SES CLASS 2" SELECT SES=2 count /q * in the next line we use a resultvariable called $count: * resultvariables are shown with the command "result" imif $count > 0 then TABLES SEX ILLNESS else type "No observations" endif Select Regards Jens Lauritsen EpiData Association

1 0

Incomplete execution of PGM
by epidata-list＠lists.umanitoba.ca 20 Aug '07

20 Aug '07

Dear All, I am bringing to your kind attention one more and last problem. Hopefully this will be looked into before the release of ver 2 of Epidata Analysis. I have a sample database of distribution of illness according to the socio- economic status in the population. The socio- economic status is divided into 1,2 and 3 classes. The sample SES.pgm is listed below.. *SES.PGM CLS CLOSE SET ECHO=OFF READ "D:\EPIDATA\SES\SES.REC" TYPE "\LTABLE SHOWING ILLNESS IN THE SES CLASS 1" SELECT SES=1 TABLES SEX ILLNESS SELECT TYPE "\LTABLE SHOWING ILLNESS IN THE SES CLASS 2" SELECT SES=2 TABLES SEX ILLNESS SELECT TYPE "\LTABLE SHOWING ILLNESS IN THE SES CLASS 3" SELECT SES=3 TABLES SEX ILLNESS SELECT *END OF PGM When I run the PGM, following output is generated. TABLES SHOWING ILLNESS IN THE SES CLASS 1 Sex Illness F M Total N 2 1 3 Y 0 3 3 Total 2 4 6 TABLES SHOWING ILLNESS IN THE SES CLASS 2 No data! Operation aborted Since there is no data in the socio-economic class 2, the PGM aborts the operation. The rest of the PGM is not processed. I am attaching a sample SES.ZIP containing the necessary qes, chk and rec files. The latest test ver 2 (build 112b) of Epi Analysis was used. If this feature is looked into, large PGMs can be run without sny break. Is there any solution of this problem? Dr. Shavinder Singh

1 0

reuse labels in several files
by epidata-list＠lists.umanitoba.ca 17 Aug '07

17 Aug '07

epidata-list-request(a)lists.umanitoba.ca wrote: > Often, one uses questionnaires where the items and a value labels might > be identical for dozens or more questions. It seems that EpiData creates > a block in the .CHK file that applies to one variable only. Is there a > way to apply the same checks and labels to several variables at the same > time? > Technique 1: Common label definitions in EpiData.LBL. When you start EpiData Entry there is a default label collection. If you often use the same labels then edit the file EpiData.lbl which you will find in the same folder as the EpiData Enter system (epidata.exe) installed. Then for a given new file create the rec file and in the Enter system use "Add/revise" to add checks to the file. a Go to the first of the variables which should have a given label b. Choose from the list of your predefined labels contained in "Epidata.lbl" and read into the definition box. c. Now switch back to the field in question (F6 goes from the definition box to the field and vice versa). d. Press Ctrl+C e. Move the cursor to each of the other fields and press Ctrl+V and the definition is copied. It takes very short time. If you are thing instead of missing values etc. look in the help file: MISSINGVALUE Missing value has three syntaxes: MISSINGVALUE x [y [z]] which can be used in fieldblocks, and MISSINGVALUE ALL x [y [z]] which can be used in BEFORE FILE blocks, and MISSINGVALUE field1-field5, field6 …. x [y [z]] which can be used in BEFORE FILE blocks You see that in this case you can use syntax similar to Stata x-y . But for labels the trick above is the only possible. Technique 2: automatic revise of a larger file for subsets: The other technique to use is to create a common (large) file with all relevant questions, properly labelled. Then for a given substudy do: 1. create copies of the common large rec file and associated chk file 2. create copy of qes file 3. edit the qes file and delete sections not currently needed. 4. choose the rec file for entering data. Enter will "see" that the qes file has a more recent date and time and will suggest to adapt the structure to the qes file. Say yes to this and you will see that a number of no longer used variables will be removed including the chk for those. In terms of the analysis programme the issue is somewhat different, but I read the question as being relevant for entry. regards Jens Lauritsen EpiData Association

1 0

Epidata: apply the same value labels and validity checks to many variables
by epidata-list＠lists.umanitoba.ca 17 Aug '07

17 Aug '07

Hi, Often, one uses questionnaires where the items and a value labels might be identical for dozens or more questions. It seems that EpiData creates a block in the .CHK file that applies to one variable only. Is there a way to apply the same checks and labels to several variables at the same time? I appreciate that one can go into a text editor and copy the block as many times as necessary and then changing the variable names. it would be great if one could use syntax similar to SPSS or Stata where information can be applied to a variable list such as VAR001-VAR010 the same way it is applied to individual variables. Thanks! 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 1

Relational Files Relate Error
by epidata-list＠lists.umanitoba.ca 14 Aug '07

14 Aug '07

Dear All, I have a relational database comprising of 8 data entry forms. The structure is as follow; FFNO FAMIDNUM CARD Family --------------- Ecouple ----------------------- Under5 ------ Growth Monitoring form | | | | | FFNO | CSNO | | | | Agesex Form Contraception The field names in capital are unique key fields for relating the form during data entry. When I relate Growth Monitoring form Under5 form, the relating happens. When I relate Under5 Form with Ecouple the following message is displayed. Loading data D:\EpiData\Try\Gm.rec, please wait.. Excluded: 1243184 records marked for deletion File name : D:\EpiData\Try\Gm.rec Growth Monitoring Register Fields: 9 Total records: 6 Included: 6 . relate card UNDER5 Loading data D:\EpiData\Try\UNDER5.REC, please wait.. Excluded: 1243148 records marked for deletion File name : D:\EpiData\Try\UNDER5.REC . relate FAMIDNUM Ecouple Loading data D:\EpiData\Try\Ecouple.REC, please wait.. Excluded: 1243148 records marked for deletion 1 4218388 The relation happens only up to 2 forms only. What is meant by the error message 1 4218388 Is there any way out. I am doing it through EPI6 at present which does it seamlessly. Do we still have development issue regarding RELATE command in the Epidata Analysis (Ver 2 Build 112b). I am attaching this sample database in the form of CHC ZIP. Please enlighten upon this problem. Sincerely, Dr. Shavinder .

1 1

EpiData-list Digest
by epidata-list＠lists.umanitoba.ca 14 Aug '07

14 Aug '07

Hello, Two questions : - in the last version (build 122), how to obtain the same result with "set table label = on/ff" than anterior versions ? - in the further versions, is it possible to obtain a box-plot with two or more co-variables ? Thank you B. Branger, Nantes, France

1 0

Floating point error in analysis (describe)
by epidata-list＠lists.umanitoba.ca 06 Aug '07

06 Aug '07

re: "invalid floating pint" error with DESCRIBE in Analysis > I use the command line editor to issue DESCRIBE * command, and I get descriptive summaries of all variables, including the variable called AMOUNT. > > But when I issue the command DESCRIBE AMOUNT, I get an error message: Invalid floating point operation > > Please do the following: 1. Download the most recent testing version of EpiData Analysis: www.epidata.dk/testing.php 2. Retry the same analysis 3. Report to the list if the problem persisted. 4. If the problem persisted: a. pack your data file in a zip file (e.g. with epidata entry - tools menu). b. report the error to the epidata mantis system http://www.epidata.dk/php/mantis/login_page.php and upload the zip file as part of the error report. Kind regards Jens Lauritsen EpiData Association

1 2

how to sum numeric variables even if one of the variables is empty
by epidata-list＠lists.umanitoba.ca 06 Aug '07

06 Aug '07

Hello I would like to make an automatic sum (see: variable "daystotadm") of a series of variables (see: variable "daysadm1-2..."), but if only one of these variable is empty, the automatic calculation using the function SUM give a null result. Do anyone know a way to solve this problem without the need to enter a value for each variable. In my file I don not necessarily enter all the five lines and the number of days is already a calculated field? I attach the qes and the check files Thank you Francesco Grandesso QES FILE --------------------------------------------------------------------------------- Date of entry Date of exit Number of days -------------------------------------------- --------------- {dateentry1} <dd/mm/yyyy> {dateexit1} <dd/mm/yyyy> {daysadm1} ### {dateentry2} <dd/mm/yyyy> {dateexit2} <dd/mm/yyyy> {daysadm2} ### {dateentry3} <dd/mm/yyyy> {dateexit3} <dd/mm/yyyy> {daysadm3} ### {dateentry4} <dd/mm/yyyy> {dateexit4} <dd/mm/yyyy> {daysadm4} ### {dateentry5} <dd/mm/yyyy> {dateexit5} <dd/mm/yyyy> {daysadm5} ### -------------------------------------------- --------------- {daystotadm} Total days #### CHK FILE ---------------------------------------------------------------------------------- dateexit1 AFTER ENTRY daysadm1=(dateexit1-dateentry1) daystotadm=SUM(daysadm1,daysadm2,daysadm3,daysadm4,daysadm5) END END daysadm1 NOENTER END .................... and so on for each of the five dateexit* and daysadm* variables __________________________________________ Francesco Grandesso EPICENTRE 8, Rue Saint Sabin 75011 Paris, France tel +33 (0)1 4021 2847 fax +33 (0)1 4021 2803 email Francesco.GRANDESSO(a)epicentre.msf.org

1 1

Chris Sellers/FHS/ADPH is out of the office.
by epidata-list＠lists.umanitoba.ca 04 Aug '07

04 Aug '07

I will be out of the office starting 08/03/2007 and will not return until 08/09/2007. I will check emails periodically while I am away. If an issue needs immediate attention, please, contact Fred Grady at FredGrady(a)adph.state.al.us. Otherwise, I will respond to your email when I return.

1 0

Command Set replace logfile=on
by epidata-list＠lists.umanitoba.ca 04 Aug '07

04 Aug '07

Dear Epidata Team friends, I want to get the html file output form datafile by a PGM. I want to replace the previous output in the defined folder by the new output. The commands in my PGM are as follows; Set replace logfile=on Logopen The quarterly report file . 2007 /close Error message displayed is Replace Logfile not supported I change Set replace logfile=on to another command set replace datafile=on That also does not help. The help file about /close , /replace switches of Logopen command is not clear because it does not work as expected. If you close and reload Epidata Analysis, it works only once and displays error message when the PGM is run second time in the same session. What is the right command syntax? I am using trial version 2 (build 112). With regards, Shavinder Singh

1 0

Command Set replace logfile=on
by epidata-list＠lists.umanitoba.ca 03 Aug '07

03 Aug '07

Dear Epidata Team friends, I want to get the html file output form datafile by a PGM. I want to replace the previous output in the defined folder by the new output. The commands in my PGM are as follows; Set replace logfile=on Logopen The quarterly report file . 2007 /close Error message displayed is Replace Logfile not supported I change Set replace logfile=on to another command set replace datafile=on That also does not help. The help file about /close , /replace switches of Logopen command is not clear because it does not work as expected. If you close and reload Epidata Analysis, it works only once and displays error message when the PGM is run second time in the same session. What is the right command syntax? I am using trial version 2 (build 112). With regards, Shavinder Singh

1 0

Summing a number of variables
by epidata-list＠lists.umanitoba.ca 03 Aug '07

03 Aug '07

The easiest way of summing: > I would like to make an automatic sum (see: variable "daystotadm") of a > series of variables (see: variable "daysadm1-2..."), but if only one of > these variable is empty, the automatic calculation using the function SUM > give a null result. > What I would do is: dateexit1 AFTER ENTRY if dateexit1 = . then goto daysadm1 endif end end dateexit2 AFTER ENTRY if dateexit2 = . then goto daysadm endif end end etc for the other dateexit3 to 5. daysadm before entry * assume you have at least data in the first var: daysadm=(dateexit1-dateentry1) if dateexit2 <> . then daystotadm =(dateexit2-dataentry2) + daysadm endif if dateexit3 <> . then daystotadm =(dateexit3-dataentry3) + daysadm endif if dateexit4 <> . then daystotadm =(dateexit4-dataentry4) + daysadm endif if dateexit5 <> . then daystotadm =(dateexit5-dataentry5) + daysadm endif goto ... next variable end end In this way when the first dateexit is equal to ., the program jumps and no entry is needed in ... up to number 5 variable. (I hope the comparison of date variable with . works - did not test it). Regarding the other question from yesterday. Installation of EpiData software (entry and analysis) is always very "clean", meaning not disturbing the PC, so you can have many copies if you wish for various purposes. Just copy the exe file (plus help if needed). When testing I tend to create the default for testing as: c:\epidataanalysistest such that the test version of analysis does not interfere with the release version. regards jens lauritsen EpiData Association

1 0

"invalid floating pint" error with DESCRIBE in Analysis
by epidata-list＠lists.umanitoba.ca 02 Aug '07

02 Aug '07

I have a small data file, created in EpiData 3.1 on Windows XP. It consists of 7 records and 8 variables. I load the data into Analysis version 1.1 build 68. I use the command line editor to issue DESCRIBE * command, and I get descriptive summaries of all variables, including the variable called AMOUNT. But when I issue the command DESCRIBE AMOUNT, I get an error message: Invalid floating point operation See attached html file. Any suggestions how I could solve this problem? Thanks. -- Christopher W. Ryan, MD SUNY Upstate Medical University Clinical Campus at Binghamton 40 Arch Street, Johnson City, NY 13790 cryanatbinghamtondotedu PGP public keys available at http://home.stny.rr.com/ryancw/ "If you want to build a ship, don't drum up the men to gather wood, divide the work and give orders. Instead, teach them to yearn for the vast and endless sea." [Antoine de St. Exupery]

1 0