Statalist The Stata Listserver


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

st: merge


From   Daniel.Hoechle@unibas.ch
To   statalist@hsphsun2.harvard.edu
Subject   st: merge
Date   Fri, 28 Jul 2006 10:37:33 +0200

Dear all

I'm using Stata 9.1. In DBQ.dta, variables Year and Quarter uniquely identify
all observations (i.e. quarterly data). However, in DBM.dta this is not the
case since this database contains monthly data.

Typing
. merge Year Quarter using DBQ.dta, uniqusing sort

Yields the following error message:
variables Year Quarter do not uniquely identify observations in the master data
r(459);

Although Stata's observation is correct, I wonder why this error occurs.
Actually, Stata's error message is what I wanted to express in the -merge-
command... ("1:n merge")

Can you replicate this error (even for Stata 9.2)? How can I assure that Stata
returns an error when the "using dataset" is not uniquely identified by
varlist?

Thanks a lot for looking into this matter.

Kind regards,
Daniel






----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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