Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data cleansing: how to eliminate inconsistency?

    Good morning, I'm working with a secondary database and I want to eliminate the people who report inconsistency:

    That is, if the ages of the people reported by duplicity are different.

    Annex dataex example. Thank you for your support.

    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input str7(NAME APELLIDO) float AGE
    "JUAN"   "LOPEZ"   10
    "MIGUEL" "LOPEZ"   11
    "JAIME"  "LOPEZ"   13
    "LIZ"    "LOPEZ"   15
    "LAURA"  "RAMIREZ" 20
    "PIERA"  "RAMIREZ" 20
    "LUIS"   "RAMIREZ" 40
    "CARLOS" "SANCHEZ" 50
    "ARTURO" "SANCHEZ" 33
    "DIEGO"  "SANCHEZ" 45
    "JANINA" "SANCHEZ" 48
    "MIGUEL" "LOPEZ"   13
    "JAIME"  "LOPEZ"   13
    "DIEGO"  "SANCHEZ" 23
    "LUIS"   "RAMIREZ" 30
    end

  • #2
    FAQ https://www.stata.com/support/faqs/d...ions-in-group/

    Comment


    • #3
      Many thanks, i served a lot of nick

      Comment

      Working...
      X