[EpiData-list] Re: EpiData-list Digest, Vol 56, Issue 5

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Tue Jun 10 15:13:44 CDT 2008


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 at lists.umanitoba.ca>:

> Send EpiData-list mailing list submissions to
>        epidata-list at 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 at lists.umanitoba.ca
>
> You can reach the person managing the list at
>        epidata-list-owner at 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 at lists.umanitoba.ca)
>   2. EpiData Analysis notes (epidata-list at lists.umanitoba.ca)
>   3. RE: If..then (epidata-list at lists.umanitoba.ca)
>   4. Re: Re: Outbreak analysis diary - multiple data   sets
>      (epidata-list at lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 10 Jun 2008 12:04:34 +1200
> From: epidata-list at lists.umanitoba.ca
> Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple
>        data    sets
> To: <epidata-list at lists.umanitoba.ca>
> Message-ID: <484E6DD2020000CA00016D7A at 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 at lists.umanitoba.ca
> Subject: [EpiData-list] EpiData Analysis notes
> To: <epidata-list at lists.umanitoba.ca>
> Message-ID:
>        <AD682418821AA34BAB0650CECBC8B92D074D02 at 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 at 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 at lists.umanitoba.ca
> Subject: RE: [EpiData-list] If..then
> To: <epidata-list at lists.umanitoba.ca>
> Message-ID: <ED5A894B497B0040A17FD2AE66D789B07517B1 at 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 at lists.umanitoba.ca [mailto:
> epidata-list at lists.umanitoba.ca]
> Envoyé : mercredi 28 mai 2008 17:48
> À : epidata-list at 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 at lists.umanitoba.ca
> Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple
>        data    sets
> To: epidata-list at lists.umanitoba.ca
> Message-ID: <484E6770.8070508 at 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 at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 56, Issue 5
> *******************************************
>


More information about the EpiData-list mailing list