[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: merging without repeat obs in master dataset

From   "Michael Blasnik" <>
To   <>
Subject   st: Re: merging without repeat obs in master dataset
Date   Fri, 23 May 2008 07:03:47 -0400


Your first statement is incorrect -- merge does not require a unique key unless you tell it that's what you expect/want/require.
Just omit the -sort- option to your merge command and it will work. The help for -merge- notes that -sort- implies that the key is unique in both datasets.

M Blasnik

----- Original Message ----- From: "Mingfeng Lin" <>
To: <>
Sent: Thursday, May 22, 2008 10:51 PM
Subject: st: merging without repeat obs in master dataset


The -merge- command in Stata requires that the variable to merge
uniquely identify observations in the master dataset.  But how should
I merge if the variable I would like to merge on does not uniquely
identify master dataset observations?

For instance:
Master: ID GROUP
(multiple IDs could be in the same group)


I wanted to do
.merge GROUP using ..., sort

error message r(459):  something that should be true of your data is not;

My final dataset should have each ID as an observation. Is there
something I can do to work around this?

Thank you!

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index