checking for duplicate records
Is there an easy way to check for duplicate records during data cleaning after data entry? Currently we export EpiData sets to MS Excel and run a little routine - but maybe someone has some within EpiData solution. Tx Max
Dear fellow, There is a way for checking duplicating records in epi data usi procedure 1. on the menu bar go to document 2 .slect validate duplicate files NB:name the file eg.a and b and when you select option 2 3 put appropriate file in file 1 or 2 and it will check it for you.
or the order option is to go to view data and sort the data and it will show you the duplicate files.
On Mon, January 16, 2006 2:23 am, epidata-list@lists.umanitoba.ca wrote:
Is there an easy way to check for duplicate records during data cleaning after data entry? Currently we export EpiData sets to MS Excel and run a little routine - but maybe someone has some within EpiData solution. Tx Max
Thanks - but the first way did not work for me and the second is too tedious in case you have 4000 records in the file and you want to spot 5 duplicate IDs in them. How would you get Document>Validate Duplicate Files finding within one dataset the few duplicates? Even if I make a copy with a different name - it only checks that they are identical... Tx Max
On 17 Jan 2006, at 23:38, epidata-list@lists.umanitoba.ca wrote:
Dear fellow, There is a way for checking duplicating records in epi data usi procedure
- on the menu bar go to document
2 .slect validate duplicate files NB:name the file eg.a and b and when you select option 2 3 put appropriate file in file 1 or 2 and it will check it for you.
or the order option is to go to view data and sort the data and it will show you the duplicate files.
On Mon, January 16, 2006 2:23 am, epidata-list@lists.umanitoba.ca wrote:
Is there an easy way to check for duplicate records during data cleaning after data entry? Currently we export EpiData sets to MS Excel and run a little routine - but maybe someone has some within EpiData solution. Tx Max
-- SEDZRO KOJO MENSAH P.O.Box AS 387 Ashaiman -Tema Ghana House : +233-22-300789 MOBILE : +233-244-458788 Homepage http://rastafarionline.com/rasbesa
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
participants (1)
-
epidata-list@lists.umanitoba.ca