- EpiData-list - University of Manitoba Mailing Lists

RE: [EpiData-list] Relational database
by epidata-list＠lists.umanitoba.ca 03 Jun '05

03 Jun '05

In order to add only 1 related record (thus automatically go back to 'mother' datafile as soon 1 related record has been saved, just add '1' (without ') at the end of the RELATE command Example: RELATE IDENTFIELD DATAFILE2.REC 1 Best regards, ______________________________________________ Gilles DELMAS Institut de Veille Sanitaire Dept. Maladies Infectieuses, Unité infections entériques, alimentaires et zoonoses 12 rue du Val d'Osne 94415 Saint-Maurice cedex - France + 33 1 41 79 67 27 g.delmas(a)invs.sante.fr ______________________________________________ -----Message d'origine----- De : epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Envoyé : mercredi 1 juin 2005 16:36 À : epidata-list(a)lists.umanitoba.ca Objet : [EpiData-list] Relational database Hello! I have long questionnaire, so I divided it into two parts using through relational database. At the end of part 2, the EpiData is starting again part 2, taking it as new subrecord. How can I let EpiData start new record in part 1 (i.e. for a new person)? Thank you in advance! /Ziad

1 0

Topics in EpiData-List
by epidata-list＠lists.umanitoba.ca 02 Jun '05

02 Jun '05

The EpiData-list has been set up with two topics today: Analysis Data Entry A topic is a way to selectively receive only part of the mails from the discussion list. By default ALL mails are sent to all users. Even annoying ones, such as when I forgot to turn off an "out of office" message to the list last week (excuses) and all users received a message in Danish. How does topics work ? If a user is signed up to only "analysis", then only mails which contain the word "analysis" in the subject line or the first 15 lines of text in the body of the message will be sent to that user. If you wish to receive all mail: You do not have to do anything. If you wish to select only mails for one or the other topic: Go to this page in your browser http://lists.umanitoba.ca/mailman/options/epidata-list and edit your user profile. Further information is given on that page. For all users it is always good practice to choose wording of the subject such that other users can see what this mail is about. This is particularly true when topics are in effect. Regarding release of analysis I can inform you that we are progressing, but some errors in the basic handling of selecting data has postponed the release. The problem is related to a valid way of separating float values, such as e.g. 3.1 from 3.100000000001 and 3.097865491 Jens Lauritsen Coordinator and initiator of EpiData Project http://www.epidata.dk

1 0

value labels
by epidata-list＠lists.umanitoba.ca 02 Jun '05

02 Jun '05

Hello to all! I have being using data entry software for my work and that of epi data is very interesting and smooth but my problem is that it can not take long value label with 256 characters. Is there anyone that can give me a suggestion of defining value labels for a variable with long characters. SEDZRO KOJO MENSAH P.O.Box AS 387 Ashaiman -Tema Ghana House : +233-22-300789 MOBILE : +233-244-458788 Open WebMail Project (http://openwebmail.org) ---------- Original Message ----------- From: epidata-list-request(a)lists.umanitoba.ca To: epidata-list(a)lists.umanitoba.ca Sent: Fri, 27 May 2005 12:02:51 -0500 (CDT) Subject: EpiData-list Digest, Vol 19, Issue 9 > 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..." ------- End of Original Message -------

1 0

Relational database
by epidata-list＠lists.umanitoba.ca 01 Jun '05

01 Jun '05

Hello! I have long questionnaire, so I divided it into two parts using through relational database. At the end of part 2, the EpiData is starting again part 2, taking it as new subrecord. How can I let EpiData start new record in part 1 (i.e. for a new person)? Thank you in advance! /Ziad

1 0

(no subject)
by epidata-list＠lists.umanitoba.ca 31 May '05

31 May '05

Hi!everyone. I just obtain EPIDATA and I find it very useful. But I cann't analyze the data with Spss. Does Epidata have fountion to transform *.rec to *.sav? 　　　　　　　　致礼！　　　　　　　　stephen 　　　　　　　　stephen_ling(a)163.com 　　　　　　　　　　2005-05-31

1 2

Vedr.: [EpiData-list] (no subject) (Kontakt til Jens Lauritsen Uge 8 )
by epidata-list＠lists.umanitoba.ca 31 May '05

31 May '05

Jens Lauritsen, Overlæge afd.O-Ulykkes Analyse Gruppen, Odense Universitetshosptal Tæffes igen 1.juni. Kontakt evt. sekretariatet på (+45) 65412283 Ved hastesager kan der indtales besked på (+45) 21732293 Will be back June 1st.

1 0

RE: Date variable
by epidata-list＠lists.umanitoba.ca 27 May '05

27 May '05

Hi! The 3 variables (Day, Month and Year) have to be string (or at least, it works that way!) Assuming following variable names : Date: DATE, Day: DAY, Month: MONTH, Year: YEAR) In the After entry block of the date variable, place the lines below: DAY = day(DATE) MONTH = month(DATE) YEAR = year(DATE) Day, month and year are functions which automatically extract the corresponding values. Note: besste to create string variables, so days / months < 10 will stay the way thay have been entered, (03 will wtay 03 and not 3). Best regards Gilles -----Message d'origine----- De : epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Envoyé : vendredi 20 mai 2005 05:05 À : epidata-list(a)lists.umanitoba.ca Objet : [EpiData-list] Date variable Hi all! I am trying to create three variables: Day, Month and Year that would read automatically their values from Date variable (<dd/mm/yyyy>) but unfortunately can't get well how to do it, Any tips please? Thank You in advance! Best regards! /Ziad -- Medecins Sans Frontieres - Holland NorthSudan project Upper Nile State

1 0

RE: [EpiData-list] Re: selecting on string variables
by epidata-list＠lists.umanitoba.ca 25 May '05

25 May '05

Why is this necessary? I see "LION", upper case and delineated with " ". Thanks, Kelly -----Original Message----- From: epidata-list(a)lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Sent: Sunday, May 01, 2005 2:16 PM To: epidata-list(a)lists.umanitoba.ca Subject: [EpiData-list] Re: selecting on string variables > 1. How to select "string variables" in Epidata Analysis ? > select outcome="death" An example should clarify: Try this: generate 3 // make 3 artificial records gen integer id = recnumber // create id variable define animal _________ // make a string variable * add value to the variable: if recnumber = 3 then animal = "monkey" if recnumber = 1 then animal = lower("LION") if recnumber = 2 then animal = "LION" . list ID ANIMAL 1 lion 2 LION 3 MONKEY * so we see that we have three values for the variable animal. * and we have two variables: . var Name Type Length Decimals ID Integer 12 0 ANIMAL String 9 0 %s9 * now we try various selects: select if animal = "LION" count No records available select // to select if upper(animal) = "LION" count No records available select select if upper(trim(animal)) = "LION" count Count : 2 The essense is therefore that to do a select on a string variable, you have to use as well sometimes the function upper() and the function trim() to get a proper selection. regards Jens Lauritsen Initiator of EpiData Coordinator EpiData Association

1 0

Creating three variables from one
by epidata-list＠lists.umanitoba.ca 21 May '05

21 May '05

Dear Ziad: I am not sure I understood you correctly, but if yes, this is what you would do: QES file: testdate <dd/mm/yyyy> dd ## mm ## yyyy #### sex <A> and CHK file: testdate MUSTENTER after entry dd=day(testdate) mm=month(testdate) yyyy=year(testdate) end end DD NOENTER END MM noenter END YYYY NOENTER END SEX MUSTENTER END Regards, Hans -- Hans L Rieder, MD, MPH Jetzikofenstr. 12 3038 Kirchlindach Switzerland Tel: +41 31 829 4577 Mob: +41 79 429 9945 Web: http://www.tbrieder.org

1 0

Date variable
by epidata-list＠lists.umanitoba.ca 19 May '05

19 May '05

Hi all! I am trying to create three variables: Day, Month and Year that would read automatically their values from Date variable (<dd/mm/yyyy>) but unfortunately can't get well how to do it, Any tips please? Thank You in advance! Best regards! /Ziad -- Medecins Sans Frontieres - Holland NorthSudan project Upper Nile State

1 0