C:\_EpiBook\Examples\exClinic\Analysis\Duplicates.htm

Epi Info


Current View:Analysis.MDB:viewPatients
Relate:CountDups
Select:CountDups > 1
Record Count:10(Deleted records excluded) Date:12/26/2009 9:14:20 AM
Duplicate Clinic ID (ID2)


Current View:Analysis.MDB:viewPatients
Relate:CountDups
Select:CountDups > 1
Sort:ID ID2
Record Count:10(Deleted records excluded) Date:12/26/2009 9:14:20 AM

List ID ID2 CountDups Pediatric FamilyName Name Age Sex InitialDate columnsize=10



ID ID2 CountDups Pediatric FamilyName Name Age Sex InitialDate
0 8291 2 No AZELI Eliaz 44 M 04-13-2007
0 8291 2 . AZELI Eliaz . . 04-13-2007
0 8611 2 No SALUI Luis 33 F 10-18-2007
0 8657 2 No E EJOS Jose 43 M 11-23-2007
0 8657 2 No E EJOS Jose 24 F 11-23-2007
0 8839 2 Yes EYDANER nerey . . 03-25-2008
637 8283 2 No IAMAR Mari 36 F 04-13-2007
846 8839 2 No EYDANER nerey 32 F 03-25-2008
6076 8283 2 Yes IAMAR Mari 1 M 04-13-2007
6094 8611 2 Yes SALUI Luis 1 F 10-18-2007




Current View:Analysis.MDB:viewPatients
Record Count:335(Deleted records excluded) Date:12/26/2009 9:14:20 AM

SUMMARIZE CountDups :: Count(ID) TO CountDupName STRATAVAR=Name Familyname





Output table created: C:\_EpiBook\Examples\exClinic\Analysis\Analysis.mdb:CountDupName

Current View:Analysis.MDB:viewPatients
Relate:CountDupName
Select:CountDups > 1
Record Count:78(Deleted records excluded) Date:12/26/2009 9:14:20 AM
Duplicate Name and Familyname


Current View:Analysis.MDB:viewPatients
Relate:CountDupName
Select:CountDups > 1
Sort:FamilyName Name
Record Count:78(Deleted records excluded) Date:12/26/2009 9:14:20 AM

List ID ID2 CountDups Pediatric FamilyName Name Age Sex InitialDate columnsize=10



ID ID2 CountDups Pediatric FamilyName Name Age Sex InitialDate
701 8361 2 No AROS Rosa 46 F 07-24-2007
0 8853 2 No AROS Rosa 23 F 03-27-2008
0 8291 2 No AZELI Eliaz 44 M 04-13-2007
0 8291 2 . AZELI Eliaz . . 04-13-2007
0 8277 2 No CALI Alic 37 F 04-12-2007
0 8755 2 No CALI Alic 30 F 02-01-2008
0 8657 2 No E EJOS Jose 24 F 11-23-2007
0 8657 2 No E EJOS Jose 43 M 11-23-2007
758 8587 2 No E MIJOS Jose 43 M 10-12-2007
6096 8651 2 Yes E MIJOS Jose 6 M 11-21-2007
579 8013 2 No EARG Arge 41 F 12-11-2006
0 8777 2 No EARG Arge 29 F 02-11-2008
0 8843 2 No ERVAMIN Min 27 F 02-28-2008
824 8785 2 No ERVAMIN Min 36 F 02-15-2008
0 8839 2 Yes EYDANER nerey . . 03-25-2008
846 8839 2 No EYDANER nerey 32 F 03-25-2008
0 8865 2 No GARIMAR Marga 40 F 04-16-2008
753 8521 2 No GARIMAR Marga 21 F 09-17-2007
645 8253 2 No GMAR Marg 21 F 03-19-2007
0 8789 2 . GMAR Marg . F 02-18-2008
6076 8283 2 Yes IAMAR Mari 1 M 04-13-2007
637 8283 2 No IAMAR Mari 36 F 04-13-2007
0 8861 3 No IAMAR Maria 48 F 03-28-2008
762 8463 3 No IAMAR Maria 20 F 05-25-2007
818 8761 3 No IAMAR maria 42 F 02-05-2008
648 8309 2 No IBEMAR Mari 40 F 03-12-2007
0 8747 2 No IBEMAR MARI 42 F 01-28-2008
6072 8229 2 Yes IDDAV David 9 M 02-28-2007
0 8507 2 No IDDAV David 28 M 09-11-2007
595 8195 2 No IFEL Feli 41 M 01-23-2007
6031 10027 2 Yes IFEL Feli 17 F 03-29-2001
0 8981 2 No IJUL Juli 83 F 10-04-2007
0 8963 2 No IJUL Juli 37 M 12-27-2005
0 8697 2 No ILMAR Maril 37 F 12-21-2007
0 8653 2 No ILMAR Maril 32 F 11-22-2007
0 8191 2 No IYUN Yuni 27 M 01-24-2007
580 8043 2 No IYUN Yuni 31 M 12-28-2006
0 8181 2 Yes JUL Jul 4 M 11-07-2006
0 8685 2 Yes JUL Jul . . .
0 8447 2 No LOPAB Pablo 42 M 08-06-2007
652 8315 2 No LOPAB Pablo 38 M 05-02-2007
0 8421 3 No MAR Mar 24 F 07-24-2007
656 8319 3 No MAR Mar 31 F 05-08-2007
0 8859 3 No MAR Mar 40 F 11-27-2007
0 8199 2 No NAJUA Juana 20 F .
0 8971 2 No NAJUA Juana 27 F 06-09-2008
769 8607 2 No NCFRA Franc 28 F 10-22-2007
0 8991 2 No NCFRA Franc 35 M .
635 8237 2 No NFRA Fran 31 M 03-09-2007
841 8847 2 No NFRA Fran 87 M 03-26-2008
680 8377 5 No NJUA Juan 28 M 06-19-2007
0 8819 5 No NJUA juan 29 M 03-10-2008
0 8973 5 No NJUA Juan 31 M 06-11-2008
667 8351 5 No NJUA Juan 44 M 05-30-2007
849 8885 5 . NJUA juan . M 04-14-2008
785 8673 2 No NLEO Leon 39 M 11-29-2007
788 8659 2 No NLEO leon 53 F 11-27-2007
733 8505 2 No OLITHIP Hipolit 60 M 09-11-2007
0 8975 2 No OLITHIP Hipolit 68 M 06-11-2008
0 8601 2 Yes ONRAM Ramon . . .
0 8757 2 No ONRAM Ramon 30 F 01-30-2008
821 8141 2 No RIAGLO Gloria 87 F 01-22-2007
0 8219 2 No RIAGLO Gloria 29 F 11-20-2006
0 8655 2 No RPED Pedr 45 M 11-26-2007
599 8211 2 No RPED Pedr 44 M 02-06-2007
0 8611 3 No SALUI Luis 33 F 10-18-2007
6094 8611 3 Yes SALUI Luis 1 F 10-18-2007
0 8833 3 No SALUI Luis 23 F 10-17-2007
0 8635 2 Yes SALUI Luisa . . .
726 8491 2 No SALUI Luisa 50 F 09-03-2007
663 8345 2 No THMAR Marth 26 F 05-25-2007
0 8143 2 No THMAR Marth 33 F 01-23-2007
808 8725 2 . TORHEC Hecto . M 01-09-2008
855 8911 2 No TORHEC Hecto 39 M 04-23-2008
840 8849 2 No TOSAN santo 31 M 03-27-2008
829 8795 2 No TOSAN santo 50 M 02-21-2008
0 8375 2 No UELMIG Miguel 29 M 07-30-2007
613 8223 2 No UELMIG Miguel 35 M 03-05-2007