Announcement

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

  • variable does not uniquely identify observations in the using data

    Hi I'm working with two data bases but there they don't have the same observations. The first one belongs to the year 1996 and the second one to the year 2010, So the one from 1996 has 335711 observations and the other one 782970. They both have the variable coduni_96 but this variable is a code number for the universities from 1996 however I can't do the merge because I have an m:m problem. Any thoughts?

  • #2
    Rocio:
    no thought with no data, but an advice: stay away from -m:m-.
    Kind regards,
    Carlo
    (Stata 15.1 SE)

    Comment


    • #3
      I don't see why you're thinking of merge at all. Tell us more about what defines an observation in each dataset.

      Comment


      • #4
        Click image for larger version

Name:	Captura.PNG
Views:	1
Size:	18.1 KB
ID:	1483279

        master data
        Last edited by Rocio Nunez; 12 Feb 2019, 09:10.

        Comment


        • #5
          I don't know what I am seeing here. Are these observations individual people?

          Comment


          • #6
            Click image for larger version

Name:	1.PNG
Views:	1
Size:	29.9 KB
ID:	1483282

            using data

            thanks for the advice!

            What I need is to tab p21_1 and niveledu_padre to compare how has this variable changed over the years.
            And that also with the other variables.

            Comment


            • #7
              Yes, all of those observations are individual people who has attended to those universities.

              Comment


              • #8
                So, merge is out of the question. Possibly append makes sense.

                Comment


                • #9
                  Thanks! It worked.

                  Comment

                  Working...
                  X