Announcement

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

  • Merging data set

    I have two data sets both containing variables for years and household ID when I try to merge the data sets I get an error, does anyone know any possible solution?

    To clarify when I try to join the datasets by the variable wave which is the common variables between the datasets I get the error " variable wave does not uniquely identify observations in the master data"

    I hope this makes sense, thank you

  • #2
    It seems likely that you did
    Code:
    use A
    merge 1:1 wave using B
    and that's a problem because you need to match observations on both wave and ID
    Code:
    use A
    merge 1:1 wave ID using B

    Comment


    • #3
      Sorry for the late reply but when I try to merge 1:1 wave ID using B is till get the error "variables wave ID do not uniquely identify observations in the master data"

      Comment


      • #4
        Then try
        Code:
        merge m:1
        and see if it works.

        Also, read the output of help merge and click on the link to read the full documentation in the PDF.

        Comment

        Working...
        X