How to verify the digitation of a duplicate id secondary database

[MIGUEL IPANAQUE]

GOOD ESTIMATED NIGHTS, WHAT I WANT IS TO KNOW THE QUALITY OF THE DATA DIGITED WITHIN A SECONDARY DATABASE (, AN EXAMPLE OF AN EXAMPLE TO SEE THE QUALITY OF THE NAMES AND IF THERE IS AN ERROR IN DIGITATION AS AUTOMATED CORRECTING IT - THE EXAMPLE IS SMALL BUT IT IS LOOKING TO RETURN IT MACRO FOR THE SECONDARY BASE-

I APPRECIATE YOUR TIMES AND SUPPORT.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str12(NAME DISEASES) float var3
"JAIME LOPEZ"  "DIABETES"     .
"JAIME LOPEZ"  "CANCER"       .
"JAIME LOPEZ"  ""             .
"JULIO DIAZ"   "DIABETES"     1
"JULIO DIAS"   "DIABETES"     1
"FRANK ROMERO" ""             .
"FRANC ROMERO" ""             .
"LUIS MIGUEL"  "HYPERTENSION" .
"LUIS MIGUEL"  ""             .
end