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@lists.umanitoba.ca:
Send EpiData-list mailing list submissions to epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@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:
- Re: Re: Outbreak analysis diary - multiple data sets (epidata-list@lists.umanitoba.ca)
- EpiData Analysis notes (epidata-list@lists.umanitoba.ca)
- RE: If..then (epidata-list@lists.umanitoba.ca)
- Re: Re: Outbreak analysis diary - multiple data sets (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Tue, 10 Jun 2008 12:04:34 +1200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple data sets To: epidata-list@lists.umanitoba.ca Message-ID: 484E6DD2020000CA00016D7A@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
- Created a file and entered records (outbreak1)
- Used Tools copy structure to create a new file (outbreak 2)
- Entered records in both outbreak 1 and outbreak 2
- 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
- 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@lists.umanitoba.ca Subject: [EpiData-list] EpiData Analysis notes To: epidata-list@lists.umanitoba.ca Message-ID: AD682418821AA34BAB0650CECBC8B92D074D02@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@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@lists.umanitoba.ca Subject: RE: [EpiData-list] If..then To: epidata-list@lists.umanitoba.ca Message-ID: ED5A894B497B0040A17FD2AE66D789B07517B1@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@lists.umanitoba.ca [mailto: epidata-list@lists.umanitoba.ca] Envoyé : mercredi 28 mai 2008 17:48 À : epidata-list@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@lists.umanitoba.ca Subject: Re: [EpiData-list] Re: Outbreak analysis diary - multiple data sets To: epidata-list@lists.umanitoba.ca Message-ID: 484E6770.8070508@sympatico.ca Content-Type: text/plain; charset=ISO-8859-1; format=flowed
- 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).
- 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.
- 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@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
End of EpiData-list Digest, Vol 56, Issue 5