Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Again-Unique Case ID in Large Panel


From   Suzy <[email protected]>
To   [email protected]
Subject   Re: st: Again-Unique Case ID in Large Panel
Date   Wed, 04 Aug 2004 13:24:44 -0400

I believe that your output is saying that you have one copy of 1322511 with no surpluses (no duplicates). I just ran this yesterday with my much smaller dataset and was able to verify this.
Suzy

Stephen V. Burks wrote:


Hi, Folks.

Now I wonder if I am reporting a bug. As per Nick's suggestion
(thanks, Nick) I looked up -duplicates- and ran it.

Results:
(1) using -duplicates report-

. duplicates report DRVNUM CDATE

Duplicates in terms of DRVNUM CDATE
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 1322511 0
--------------------------------------

(2) using -duplicates list-

. duplicates list DRVNUM CDATE
Duplicates in terms of DRVNUM CDATE
(0 observations are duplicates)


If I read this correctly, one version of -duplicates- says I have
a single duplicate (the last case in the file), while the other
says I have none. Also, -xtdes- still says that DRVNUM and
CDATE do not uniquely identify cases.

I looked in the data browser, and the last case is NOT a duplicate.
While DRVNUM is the same as the case before, CDATE is not.

If my interpretation of the output is correct then my best guess is
that -xtdes- is wrong to say I do not have unique identification,
and whatever bug causes this might also be behind the apparently
incorrect response from -duplicates report-. In any event, it seems
to be a problem that -duplicates list- and -xtdes- do not agree.

Any better ideas?

Thanks,
Steve

P.S. My version of Stata is 8.2 for WinXP, with current updates.

--------------------------------------------------
*Stephen V. Burks, Ph.D.
*Assistant Professor of Economics and Management
*University of Minnesota, Morris
*
*Division of Social Sciences
*600 East 4th Street
*Morris, MN 56267-2134
*
*Voice: (320) 589-6191
*Division Staff: (320) 589-6200
*FAX: (320) 589-6117
*E-Mail: [email protected]
*
* "Striving to be the Best National
* Public Liberal Arts College in the U.S."
--------------------------------------------------- *
* 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/


*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index