- EpiData-list - University of Manitoba Mailing Lists

Re: Edit qes and keeping chk commands
by epidata-list＠lists.umanitoba.ca 13 Jun '08

13 Jun '08

Dear Susan, The tip here is never to change the variables names! You may add new variables, change the labels, change the variables places in the questionnaire. When U open the rec file, epidata will ask U to update the rec file and everything will be there. Bur if you change the variable name in the qes file, EpiData will undestand that U erased the variable and created a new one, and your data will be lost "for ever". :( The chk files follows the same principle. The name of the varible is what matters. If you want to change a varible name in a dataset wiht lots of observations then you should look in the tools menu. There is an option to change variables names. Best regards, Pedro Emmanuel Brasil 2008/6/13 <epidata-list-request(a)lists.umanitoba.ca>: > 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. simple question (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 13 Jun 2008 10:09:26 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] simple question > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <1213366166.48527f96b7cfc(a)webmail.med.yale.edu> > Content-Type: text/plain; charset=ISO-8859-1 > > When I go back and edit an ques file add questions, etc. I want to retain > the > checks from the previous ques file, but incorporate new edits to ques file. > How do I make data file w/o overwriting previous checks and/or creating > new > data file? > > Susan > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 56, Issue 8 > ******************************************* > -- Abraço forte e que a força esteja com você, Pedro Emmanuel

1 0

simple question
by epidata-list＠lists.umanitoba.ca 13 Jun '08

13 Jun '08

When I go back and edit an ques file add questions, etc. I want to retain the checks from the previous ques file, but incorporate new edits to ques file. How do I make data file w/o overwriting previous checks and/or creating new data file? Susan

1 0

Re: EpiData-list Digest, Vol 55, Issue 11
by epidata-list＠lists.umanitoba.ca 11 Jun '08

11 Jun '08

Thanks for your response. I realize the questions are rather basic, but I had perused many of the help and intro files, without finding anything that specifically addressing syntax. Perhaps the intro file for beginner users could be made more user friendly with an additional paragraph in bold under the section: Value label: For categorical data this defines the meaning of the values. E.g. 1=man 2=women. The values are edited via the + . The drop-down list lets you pick an existing label definition. ACCEPTABLE SYNTAX with all the rules spelled out, such as when quotes are necessary etc. Susan Quoting epidata-list-request(a)lists.umanitoba.ca: > 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. value labels error message (epidata-list(a)lists.umanitoba.ca) > 2. legal use? (epidata-list(a)lists.umanitoba.ca) > 3. combined numeric text variable (epidata-list(a)lists.umanitoba.ca) > 4. Re: combined numeric text variable > (epidata-list(a)lists.umanitoba.ca) > 5. Re: legal use? (epidata-list(a)lists.umanitoba.ca) > 6. Re: value labels error message (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 14 May 2008 14:26:56 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] value labels error message > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <1210789616.482b2ef0e2844(a)webmail.med.yale.edu> > Content-Type: text/plain; charset=ISO-8859-1 > > When I try to enter a string under value label LABEL Label_hablaespan > 1 espanol > 2 mayormente espanol > 3 espanol e ingles igual > 4 mayormente ingles > 5 ingles solamente > END > > It says Missing label for one or more accepted values. I have tried > entering > legal values 1-5 and/or omitting values, but I still get this message, which > I > dont know how to correct. > > > Susan Caplan > > > ------------------------------ > > Message: 2 > Date: Wed, 14 May 2008 14:30:04 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] legal use? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <1210789804.482b2facb3c80(a)webmail.med.yale.edu> > Content-Type: text/plain; charset=ISO-8859-1 > > Message recieved: > > The check file C:\Documents and Settings\Susan Caplan\My Documents\database > diss\databaseimmigrant.chk contains the following errors: > > > > Value is not compatible with this field type in line 33: > COMMENT LEGAL USE label_dm2 > > Value is not compatible with this field type in line 46: > COMMENT LEGAL USE label_dm4 > > > LABELBLOCK > LABEL label_dm2 > lang pref > 1. Spanish > 2. English > END > LABEL label_dm4 > 1. nuevo > 2. previa > END > > 1) What is wrong with the field types in the above variables? > 2) The above message continues repeating and I am not allowed to edit/revise > checks, but must clear all checks to get back into check dialogue > > > > Susan > > > ------------------------------ > > Message: 3 > Date: Wed, 14 May 2008 14:30:55 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] combined numeric text variable > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <1210789855.482b2fdfe2bd4(a)webmail.med.yale.edu> > Content-Type: text/plain; charset=ISO-8859-1 > > I want to create a variable that is numeric ## and text > ___________________________ for a fill in response such as other. However, > a > combination of text and numeric within the same variable creates two > variables. > For statistical purposes I dont want to opt for text only. Suggestions? > > > Susan Caplan, RN, MSN, FNP-BC > Yale University > PhD Student in Nursing > > > ------------------------------ > > Message: 4 > Date: Wed, 14 May 2008 21:44:22 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] combined numeric text variable > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <482B9576.9040305(a)sympatico.ca> > Content-Type: text/plain; charset=windows-1252; format=flowed > > Susan - glad to see you are using EpiData. I think you just need to look > at some of the sample files to get over the initial step of learning > some of the syntax. > > You cannot create a variable of mixed type (##____________). This will > always create two variables and this is how you need to set up your > file. Although programs like Access will let you create patterns for > data entry, they will not let you create mixed type variables. You will > find that EpiData has huge advantages. > > I suggest you just set up your data entry line as follows > > somevar ##__________________________ > > EpiData creates two fields (variables), named "somevar" and "somevar01" > - may vary depending on your settings. This is actually exactly what you > want. You can then set a range or legal values on the ## field to be > sure the entry is correct. If you need to combine them into one at some > point, this is very easy in EpiData or any other software. > > In your other postings, there are a couple of things to watch out for - > these are explained in the short introduction file. > 1) In the check file, text that has any spaces or other special > characters must be put into regular quotes > > 3 "espanol e ingles igual" > > 2) If your entry field is ##, do not use decimal points in the range or > legal values > > LABEL label_dm2 > lang pref > 1 Spanish > 2 English > END > > > While a number of us will be glad to offer help as you get started, I > encourage you to look at examples, at the list serv archives and at all > of the help files for guidance. > > Jamie > > I want to create a variable that is numeric ## and text > > ___________________________ for a fill in response such as other. > However, a > > combination of text and numeric within the same variable creates two > variables. > > For statistical purposes I dont want to opt for text only. Suggestions? > > > > > > Susan Caplan, RN, MSN, FNP-BC > > Yale University > > PhD Student in Nursing > > > ------------------------------ > > Message: 5 > Date: Thu, 15 May 2008 11:12:57 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] legal use? > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <482BFE99.9010100(a)univ-angers.fr> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > 1) The line. > > lang pref > > should be marked as a comment with a * sign at the begin of the line > > 2) the dot after the numbers should be removed. > > check file : > LABELBLOCK > LABEL label_dm2 > 1 Spanish > 2 English > END > LABEL label_dm4 > 1 nuevo > 2 previa > END > END > > The type of dm2 and dm4 must be integer of size 1 (#) > > > Message recieved: > > > > The check file C:\Documents and Settings\Susan Caplan\My Documents\database > > diss\databaseimmigrant.chk contains the following errors: > > > > > > > > Value is not compatible with this field type in line 33: > > COMMENT LEGAL USE label_dm2 > > > > Value is not compatible with this field type in line 46: > > COMMENT LEGAL USE label_dm4 > > > > > > LABELBLOCK > > LABEL label_dm2 > > lang pref > > 1. Spanish > > 2. English > > END > > LABEL label_dm4 > > 1. nuevo > > 2. previa > > END > > > > 1) What is wrong with the field types in the above variables? > > 2) The above message continues repeating and I am not allowed to > edit/revise > > checks, but must clear all checks to get back into check dialogue > > > > > > > > Susan > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > > -- > Jean-Marie Chrétien > CHU d'Angers - Centre de Recherche Clinique > 4 rue Larrey 49933 ANGERS Cedex 9 > Tel : 02.41.35.59.76 > Fax : 02.41.35.59.68 > > > > ------------------------------ > > Message: 6 > Date: Thu, 15 May 2008 11:03:14 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] value labels error message > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <482BFC52.6010508(a)univ-angers.fr> > Content-Type: text/plain; charset=windows-1252; format=flowed > > > Dear Susan, > > You must enclose your labels with double quotes when they contains spaces: > > 2 "mayormente espanol" > ... > > Jean-Marie Chrétien > > When I try to enter a string under value label LABEL Label_hablaespan > > 1 espanol > > 2 mayormente espanol > > 3 espanol e ingles igual > > 4 mayormente ingles > > 5 ingles solamente > > END > > > > It says Missing label for one or more accepted values. I have tried > entering > > legal values 1-5 and/or omitting values, but I still get this message, > which I > > dont know how to correct. > > > > > > Susan Caplan > > _______________________________________________ > > EpiData-list mailing list > > EpiData-list(a)lists.umanitoba.ca > > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > > > -- > Jean-Marie Chrétien > CHU d'Angers - Centre de Recherche Clinique > 4 rue Larrey 49933 ANGERS Cedex 9 > Tel : 02.41.35.59.76 > Fax : 02.41.35.59.68 > > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 55, Issue 11 > ******************************************** > > Susan Caplan, RN, MSN, FNP-BC Yale University PhD Student in Nursing

1 0

RE: How to use browse in the middle of analysis
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

The easy way to use browse is: Hit the F6 button. This will move control to the browse window and show all current data Obviously a pgm cannot be running in the background, but a strategy whereby: The system to help beginners is the "dialog" / menu system, which you find using the toolbar. By using the dialog there is no need to know the options for most standard possibilities. 1. For beginners: a Use the menu's and the toolbar to create a command, e.g. in analysis find the tables part b In the menu's (dialogs) there is a "more" arrow. When clicking this more options show up. By the menu's most standard options are available, but for some see the "experienced". 2. Experienced a Write the command in the command prompt. b If in doubt of options, click the F1 button and the help file for that command will be shown in the viewer. 3. Run the command / execute the command 4. When all is in place and running. Open the pgm file editor (F5) and insert history Clean up in the lines and you have your working pgm ready. Jens Lauritsen EpiData Association

1 0

Re: EpiData-list Digest, Vol 56, Issue 5
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Thank Chrystine, To solve this issue, one way (of course may not be the best) is to append datasets (providing ID are different) using EpiData Entry/Analysis which ever is convenient for you). Not sure if merge is an appropriate way for such combination of datasets. If the two datasets have some common features such as unique key values for example ID, then merge may be required to deal with it. Alternatively try append, the two file or more files should be combined to produce one. Perhaps the memory needs to be cleared prior to READ other files, then append/merge them to be READ in one file. First of all "cls" to clear the screen out then "read". Save replace, save your new dataset (golden rule). Best wishes Tieble 2008/6/10 <epidata-list-request(a)lists.umanitoba.ca>: > 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: Re: Outbreak analysis diary - multiple data sets > (epidata-list(a)lists.umanitoba.ca) > 2. EpiData Analysis notes (epidata-list(a)lists.umanitoba.ca) > 3. RE: If..then (epidata-list(a)lists.umanitoba.ca) > 4. Re: Re: Outbreak analysis diary - multiple data sets > (epidata-list(a)lists.umanitoba.ca) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 10 Jun 2008 12:04:34 +1200 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple > data sets > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <484E6DD2020000CA00016D7A(a)GW.hvh.co.nz> > Content-Type: text/plain; charset=US-ASCII > > Hi Jamie > > Sorry I sent the message without finishing my section on multiple data > sets. > > Working with Multiple data sets in Epidata Analysis > > What I was going to say was our first attempt at working with several > copies of an outbreak dataset had been sucessful. This was a timing thing - > we wanted to get the data in more quickly. We had already entered 150 > records when we decided to use another data entry person, but that was Ok > the process still worked. > > Our steps were > 1. Created a file and entered records (outbreak1) > 2. Used Tools copy structure to create a new file (outbreak 2) > 3. Entered records in both outbreak 1 and outbreak 2 > 4. Used Data in/out then Append/merge option B to create a new file > outbreak_final, that was outbreak1 and outbreak 2 combined. > > What was good about this was that it was easy, and I also really liked the > option to copy the check file we had set up for the first file to use with > the new file when you copied the structure. > The only thing I didn't like so much was we ended up with a duplicate ID > which we wouldn't get with an autoID (which we usually use for our ID field) > but I used a number field rather than AutoID this time as I thought it > would be a problem with the merge to have auto ID. > > Using Multiple data sets in Epidata Analysis - READ and multiple data sets > Could you explain a bit more about how to do this. When I try and READ more > than one data set it says "no data will be lost close first". Then - what > does the SAVEDATA do - create a new file like MERGE does? Which do you > recommend to combine data - Merging in Epidata entry or in Analysis. > > Using Epidata analysis in a field epidemilogy course > I'm very interested in how you use Epidata Analysis in your field > epidemiology course . Would I be able to find out a bit more about this from > you - perhaps off the list to avoid taking up too much time on this topic? > As I am involved in teaching courses using epidata/epi info to support field > epi I am very interested in what you cover in your courses but realise > others may not have the same interest > > Many thanks > > Christine > > > For multiple data sets (we do this every year in our Field Epidemiology > Course), you can use Merge in EpiData Entry or just READ multiple data > sets on one line in Analysis and then SAVEDATA. > > Jamie > > Christine wrote: > > I really like the outbreak analysis feature but on my wish list would be > > 1. for 'outbreak analysis' to be an option in one of the menus somewhere. > I only knew about this feature through someone mentioning it on the list and > I had to search through the docuentation to find it. Maybe this was what the > 'attack rate plus RR' option was but I could not seem to select this - it > stayed greyed out > > > 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 ** > > > > ------------------------------ > > Message: 2 > Date: Tue, 10 Jun 2008 09:39:25 +0100 > From: epidata-list(a)lists.umanitoba.ca > Subject: [EpiData-list] EpiData Analysis notes > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: > <AD682418821AA34BAB0650CECBC8B92D074D02(a)colhpaexc001.HPA.org.uk> > Content-Type: text/plain; charset="us-ascii" > > Dear Christine > > We do have notes (although different trainers have different notes to > reflect their own style). If you wish we can discuss further off-list > (e-mail neville.verlander(a)hpa.org.uk). > > Regards, > > Neville > > ------------------------------------------------------------------------ > ------------------------------------------------------------------------ > ------------------------------------------------------------------------ > ----------------------------- > Neville Verlander > Statistics Unit > Statistics, Modelling and Bioinformatics Department > Health Protection Agency Centre for Infections > 61 Colindale Avenue > London > NW9 5EQ > > Tel: (direct) (+44) (0)208 3277426 > Fax: (+44) (0)208 200 7868 > > > > > ----------------------------------------- > ************************************************************************** > The information contained in the EMail and any attachments is > confidential and intended solely and for the attention and use of > the named addressee(s). It may not be disclosed to any other person > without the express authority of the HPA, or the intended > recipient, or both. If you are not the intended recipient, you must > not disclose, copy, distribute or retain this message or any part > of it. This footnote also confirms that this EMail has been swept > for computer viruses, but please re-sweep any attachments before > opening or saving. HTTP://www.HPA.org.uk > ************************************************************************** > > ------------------------------ > > Message: 3 > Date: Tue, 10 Jun 2008 10:58:20 +0200 > From: epidata-list(a)lists.umanitoba.ca > Subject: RE: [EpiData-list] If..then > To: <epidata-list(a)lists.umanitoba.ca> > Message-ID: <ED5A894B497B0040A17FD2AE66D789B07517B1(a)xch-2.ivs.local> > Content-Type: text/plain; charset="iso-8859-1" > > Should be written as follows (only 1 argument per line) > > -----Message d'origine----- > De : epidata-list(a)lists.umanitoba.ca [mailto: > epidata-list(a)lists.umanitoba.ca] > Envoyé : mercredi 28 mai 2008 17:48 > À : epidata-list(a)lists.umanitoba.ca > Objet : [EpiData-list] If..then > > Hi, > might be easy question, i am trying to write condition under check file to > write value of 9 in 2 places if one cell equal to NA (code below), it does > not work (and no error message), any tips? > > AFTER ENTRY > IF v64=NA THEN > V65=9 > V66=9 > goto V67 > ENDIF > > > Thank you in advance > best regards > ziad > > > > ------------------------------ > > Message: 4 > Date: Tue, 10 Jun 2008 07:37:20 -0400 > From: epidata-list(a)lists.umanitoba.ca > Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple > data sets > To: epidata-list(a)lists.umanitoba.ca > Message-ID: <484E6770.8070508(a)sympatico.ca> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > 1. Merge vs. Read and Append in Analysis > > Apologies - the correct syntax to read multiple files in Analysis is: > > read file1 > append /file=file2 > > you can keep adding files. > > SAVEDATA will save a new .rec file. This is especially useful if you > have temporary variables that are used to manipulate the data. You can > do this: > > VAR DROP temp1 temp2 temp3 > SAVEDATA finaldata.rec > > Merging with Entry provides a bit of documentation of what was done and > can be automated with EPIC (but thats another level of data management). > > 2. Merge and IDNUM. I normally avoid IDNUM as it is often useful to > record ID numbers before you get to enter the data. However, you can use > IDNUM and merge data successfully, if you assign each data entry person > a unique range of IDs. In EpiData Entry, you can set an option for the > first ID to use when entering the first record of a file. It is under > File, Options and the Advanced tab. So one person could go with the > default (1) and another could change this to 1001 before entering any data. > > Another approach, where IDNUM was used and both sets of data start with > 1 (although this is really not good data mangement practice, you might > do this by including another code that indicates who entered the data). > In this case, use Analysis to merge the data as above. Analysis doesn't > care about unique ID numbers. > > 3. Field Epidemiology course and EpiData - we do a small field survey or > observational study each year. We can send more info. Contact us via the > e-mail address found at http://www.phac-aspc.gc.ca/cfep (Put my name in > the subject line). > > Jamie > > > ------------------------------ > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > > > End of EpiData-list Digest, Vol 56, Issue 5 > ******************************************* >

1 0

found it! Re: EpiData-list Digest, Vol 55, Issue 20
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Hello! managed to sort it out, pasting below the proper one if something fyi! DISP1 AFTER ENTRY IF (DRUG1="EFV") and (DOS1=600) and (DISP1>28) and (DISP1<101) THEN DAILYD1=1 GOTO DRUG2 ENDIF IF (DRUG1="EFV") and (DOS1=200) and (DISP1>118) and (DISP1<181) THEN DAILYD1=4 GOTO DRUG2 ENDIF IF (DRUG1="EFV") and (DOS1=200) and (DISP1>88) and (DISP1<110) THEN DAILYD1=3 GOTO DRUG2 ENDIF END END best regards ziad On Tue, Jun 10, 2008 at 12:08 PM, Ziad El-Khatib <ziad.khatib(a)gmail.com> wrote: > Hi again, > another question inline with previous query i posted last month, to > have different -if..then- conditions (pasted below), when i test it, > it does not write anything under DAILYD1 cell, as instructed below, > any tips? > > DISP1 > AFTER ENTRY > IF (DRUG1="EFV" & DOS1=600 & DISP1>29 & DISP1<101) THEN > DAILYD1=1 > ELSE > IF (DRUG1="EFV" & DOS1=200 & DISP1>119 & DISP1<181) THEN > DAILYD1=4 > ELSE > IF (DRUG1="EFV" & DOS1=200 & DISP1>89 & DISP1<110) THEN > DAILYD1=3 > GOTO DRUG2 > ENDIF > ENDIF > ENDIF > END > END > > > > > > Thank you and best regards > ziad > > > On Thu, May 29, 2008 at 10:03 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: If..then (epidata-list(a)lists.umanitoba.ca) >> 2. re: If..then (epidata-list(a)lists.umanitoba.ca) >> 3. Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is >> not NA (epidata-list(a)lists.umanitoba.ca) >> >> >> ---------- Forwarded message ---------- >> From: epidata-list(a)lists.umanitoba.ca >> To: epidata-list(a)lists.umanitoba.ca >> Date: Wed, 28 May 2008 20:33:07 +0200 >> Subject: Re: [EpiData-list] If..then >> Perhaps: >> >> AFTER ENTRY >> IF v64="NA" THEN >> V65=9 >> V66=9 >> goto V67 >> ENDIF >> END >> >> >> Regards, >> >> Hans >> >> >> epidata-list(a)lists.umanitoba.ca wrote: >>> >>> Hi, >>> might be easy question, i am trying to write condition under check >>> file to write value of 9 in 2 places if one cell equal to NA (code >>> below), it does not work (and no error message), any tips? >>> >>> >>> >>> Thank you in advance >>> best regards >>> ziad >>> >>> >> >> -- >> Hans L Rieder, MD, MPH >> Jetzikofenstr. 12 >> 3038 Kirchlindach >> Switzerland >> >> Tel: +41 31 829 4577 >> Mob: +41 79 321 9122 >> Web: http://www.tbrieder.org >> >> >> >> >> >> ---------- Forwarded message ---------- >> From: epidata-list(a)lists.umanitoba.ca >> To: epidata-list(a)lists.umanitoba.ca >> Date: Wed, 28 May 2008 23:33:56 +0200 >> Subject: [EpiData-list] re: If..then >> Just split in three lines: >> >> after entry >> IF v64=NA THEN >> LET V65=9 >> V66=9 >> goto V67 >> ENDIF >> >> >> regards >> Jens Lauritsen >> EpiData Association >> >> >> >> ---------- Forwarded message ---------- >> From: epidata-list(a)lists.umanitoba.ca >> To: epidata-list(a)lists.umanitoba.ca >> Date: Thu, 29 May 2008 09:05:47 -0300 >> Subject: [EpiData-list] Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is not NA >> Dear friend Ziad, >> >> NA is common expression to identify missing values. If you are working with >> R or S-Plus then NA is NA. That means that all functions or commands that >> you want to specify NA, the expression is also NA. However, in Stata or >> Epidata entry the NAs are epecified by dots (.) and sometimes by empty >> quotes (" ") depending if the variable of interest is formated as numeric or >> text. So, my guess is that your check command will work fine if do like >> this... >> >> AFTER ENTRY >> IF v64=. THEN >> LET V65=9 & V66=9 & goto V67 >> ENDIF >> END >> >> Best regards, >> Pedro Emmanuel >> >> >> >>> Today's Topics: >>> >>> 1. If..then (epidata-list(a)lists.umanitoba.ca) >>> >>> >>> ---------------------------------------------------------------------- >>> >>> Message: 1 >>> Date: Wed, 28 May 2008 08:47:34 -0700 >>> From: epidata-list(a)lists.umanitoba.ca >>> Subject: [EpiData-list] If..then >>> To: epidata-list(a)lists.umanitoba.ca >>> Message-ID: >>> <897a5cf60805280847u3b99c66ak6f49e3855b879141(a)mail.gmail.com> >>> Content-Type: text/plain; charset=ISO-8859-1 >>> >>> Hi, >>> might be easy question, i am trying to write condition under check >>> file to write value of 9 in 2 places if one cell equal to NA (code >>> below), it does not work (and no error message), any tips? >>> >>> AFTER ENTRY >>> IF v64=NA THEN >>> LET V65=9 & V66=9 & goto V67 >>> ENDIF >>> >>> >>> Thank you in advance >>> best regards >>> ziad >>> >>> >>> ------------------------------ >>> >>> ________________________________________ >>> EpiData-list(a)lists.umanitoba.ca >>> http://lists.umanitoba.ca/mailman/listinfo/epidata-list >>> >>> >>> End of EpiData-list Digest, Vol 55, Issue 19 >>> ******************************************** >>> >> >> >> ________________________________________ >> EpiData-list(a)lists.umanitoba.ca >> http://lists.umanitoba.ca/mailman/listinfo/epidata-list >> >> >

1 0

Re: EpiData-list Digest, Vol 55, Issue 20
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Hi again, another question inline with previous query i posted last month, to have different -if..then- conditions (pasted below), when i test it, it does not write anything under DAILYD1 cell, as instructed below, any tips? DISP1 AFTER ENTRY IF (DRUG1="EFV" & DOS1=600 & DISP1>29 & DISP1<101) THEN DAILYD1=1 ELSE IF (DRUG1="EFV" & DOS1=200 & DISP1>119 & DISP1<181) THEN DAILYD1=4 ELSE IF (DRUG1="EFV" & DOS1=200 & DISP1>89 & DISP1<110) THEN DAILYD1=3 GOTO DRUG2 ENDIF ENDIF ENDIF END END Thank you and best regards ziad On Thu, May 29, 2008 at 10:03 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: If..then (epidata-list(a)lists.umanitoba.ca) > 2. re: If..then (epidata-list(a)lists.umanitoba.ca) > 3. Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is > not NA (epidata-list(a)lists.umanitoba.ca) > > > ---------- Forwarded message ---------- > From: epidata-list(a)lists.umanitoba.ca > To: epidata-list(a)lists.umanitoba.ca > Date: Wed, 28 May 2008 20:33:07 +0200 > Subject: Re: [EpiData-list] If..then > Perhaps: > > AFTER ENTRY > IF v64="NA" THEN > V65=9 > V66=9 > goto V67 > ENDIF > END > > > Regards, > > Hans > > > epidata-list(a)lists.umanitoba.ca wrote: >> >> Hi, >> might be easy question, i am trying to write condition under check >> file to write value of 9 in 2 places if one cell equal to NA (code >> below), it does not work (and no error message), any tips? >> >> >> >> Thank you in advance >> best regards >> ziad >> >> > > -- > Hans L Rieder, MD, MPH > Jetzikofenstr. 12 > 3038 Kirchlindach > Switzerland > > Tel: +41 31 829 4577 > Mob: +41 79 321 9122 > Web: http://www.tbrieder.org > > > > > > ---------- Forwarded message ---------- > From: epidata-list(a)lists.umanitoba.ca > To: epidata-list(a)lists.umanitoba.ca > Date: Wed, 28 May 2008 23:33:56 +0200 > Subject: [EpiData-list] re: If..then > Just split in three lines: > > after entry > IF v64=NA THEN > LET V65=9 > V66=9 > goto V67 > ENDIF > > > regards > Jens Lauritsen > EpiData Association > > > > ---------- Forwarded message ---------- > From: epidata-list(a)lists.umanitoba.ca > To: epidata-list(a)lists.umanitoba.ca > Date: Thu, 29 May 2008 09:05:47 -0300 > Subject: [EpiData-list] Re: EpiData-list Digest, Vol 55, Issue 19 Missing values is not NA > Dear friend Ziad, > > NA is common expression to identify missing values. If you are working with > R or S-Plus then NA is NA. That means that all functions or commands that > you want to specify NA, the expression is also NA. However, in Stata or > Epidata entry the NAs are epecified by dots (.) and sometimes by empty > quotes (" ") depending if the variable of interest is formated as numeric or > text. So, my guess is that your check command will work fine if do like > this... > > AFTER ENTRY > IF v64=. THEN > LET V65=9 & V66=9 & goto V67 > ENDIF > END > > Best regards, > Pedro Emmanuel > > > >> Today's Topics: >> >> 1. If..then (epidata-list(a)lists.umanitoba.ca) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Wed, 28 May 2008 08:47:34 -0700 >> From: epidata-list(a)lists.umanitoba.ca >> Subject: [EpiData-list] If..then >> To: epidata-list(a)lists.umanitoba.ca >> Message-ID: >> <897a5cf60805280847u3b99c66ak6f49e3855b879141(a)mail.gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> Hi, >> might be easy question, i am trying to write condition under check >> file to write value of 9 in 2 places if one cell equal to NA (code >> below), it does not work (and no error message), any tips? >> >> AFTER ENTRY >> IF v64=NA THEN >> LET V65=9 & V66=9 & goto V67 >> ENDIF >> >> >> Thank you in advance >> best regards >> ziad >> >> >> ------------------------------ >> >> ________________________________________ >> EpiData-list(a)lists.umanitoba.ca >> http://lists.umanitoba.ca/mailman/listinfo/epidata-list >> >> >> End of EpiData-list Digest, Vol 55, Issue 19 >> ******************************************** >> > > > ________________________________________ > EpiData-list(a)lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list > >

1 0

Re: [EpiData-list] Re: Outbreak analysis diary - multiple data sets
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Hi Jamie Sorry I sent the message without finishing my section on multiple data sets. Working with Multiple data sets in Epidata Analysis What I was going to say was our first attempt at working with several copies of an outbreak dataset had been sucessful. This was a timing thing - we wanted to get the data in more quickly. We had already entered 150 records when we decided to use another data entry person, but that was Ok the process still worked. Our steps were 1. Created a file and entered records (outbreak1) 2. Used Tools copy structure to create a new file (outbreak 2) 3. Entered records in both outbreak 1 and outbreak 2 4. Used Data in/out then Append/merge option B to create a new file outbreak_final, that was outbreak1 and outbreak 2 combined. What was good about this was that it was easy, and I also really liked the option to copy the check file we had set up for the first file to use with the new file when you copied the structure. The only thing I didn't like so much was we ended up with a duplicate ID which we wouldn't get with an autoID (which we usually use for our ID field) but I used a number field rather than AutoID this time as I thought it would be a problem with the merge to have auto ID. Using Multiple data sets in Epidata Analysis - READ and multiple data sets Could you explain a bit more about how to do this. When I try and READ more than one data set it says "no data will be lost close first". Then - what does the SAVEDATA do - create a new file like MERGE does? Which do you recommend to combine data - Merging in Epidata entry or in Analysis. Using Epidata analysis in a field epidemilogy course I'm very interested in how you use Epidata Analysis in your field epidemiology course . Would I be able to find out a bit more about this from you - perhaps off the list to avoid taking up too much time on this topic? As I am involved in teaching courses using epidata/epi info to support field epi I am very interested in what you cover in your courses but realise others may not have the same interest Many thanks Christine For multiple data sets (we do this every year in our Field Epidemiology Course), you can use Merge in EpiData Entry or just READ multiple data sets on one line in Analysis and then SAVEDATA. Jamie Christine wrote: > I really like the outbreak analysis feature but on my wish list would be > 1. for 'outbreak analysis' to be an option in one of the menus somewhere. I only knew about this feature through someone mentioning it on the list and I had to search through the docuentation to find it. Maybe this was what the 'attack rate plus RR' option was but I could not seem to select this - it stayed greyed out 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 1

If..then
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Hi, might be easy question, i am trying to write condition under check file to write value of 9 in 2 places if one cell equal to NA (code below), it does not work (and no error message), any tips? AFTER ENTRY IF v64=NA THEN LET V65=9 & V66=9 & goto V67 ENDIF Thank you in advance best regards ziad

1 2

EpiData Analysis notes
by epidata-list＠lists.umanitoba.ca 10 Jun '08

10 Jun '08

Dear Christine We do have notes (although different trainers have different notes to reflect their own style). If you wish we can discuss further off-list (e-mail neville.verlander(a)hpa.org.uk). Regards, Neville ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------------------ ----------------------------- Neville Verlander Statistics Unit Statistics, Modelling and Bioinformatics Department Health Protection Agency Centre for Infections 61 Colindale Avenue London NW9 5EQ Tel: (direct) (+44) (0)208 3277426 Fax: (+44) (0)208 200 7868 ----------------------------------------- ************************************************************************** The information contained in the EMail and any attachments is confidential and intended solely and for the attention and use of the named addressee(s). It may not be disclosed to any other person without the express authority of the HPA, or the intended recipient, or both. If you are not the intended recipient, you must not disclose, copy, distribute or retain this message or any part of it. This footnote also confirms that this EMail has been swept for computer viruses, but please re-sweep any attachments before opening or saving. HTTP://www.HPA.org.uk **************************************************************************

1 0