You just merge them in EpiData Analysis
Say you have file a and file b. You want to merge by ID. File a has v1 v2 v3 fields and file b s1 s2 and s3
* do this: close read a merge id /file=b tab mergevar savedata ab browse id v1 v2 v3 s1 s2 s3 mergevar
You need only these lines to create a combined file for further analysis or documentation and for the first simple control of whether the combination went right. . If you have more than one variable for the merge just write them next to "id"
The mergevar variable will tell you from which file a given record/observation was found: mergevar is defined with variable labels for these values: 1 : Only in memory (original) 2 : Only in external file 3:In both
It is good practice to be very careful and compare the data before and after a merge. In particular I always look at the first, the last and some record in the middle of the file. And I always compare content with original forms.
Regards Jens Lauritsen EpiData Association
On 12-11-2014 19:24, epidata-list@lists.umanitoba.ca wrote:
Dear EpiData users and experts
I am trying to merge
two files with different number of records and fields! The first file (intake) contains 1433 records and there is 21 fields in each record. The second one contains 1301 records and and each record contains 31 fields. Each one of the 1301 record has a corresponding record in the first file (same code). I would like to merge the two files, based on the code, so that I have a third file with 1301 records and 52 fields. I tried to use the merge function in EpiData Entry, but it didn't work (the product was a file with only 47 fields instead of 52 ). I must say that some fields in the two files have the same name-can this be a reason for not merging these fields? Your help will be highly appreciated Best, MK _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list