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.

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.

(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?


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:

*   For searches and help try:

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