Nick
Sorry that I was not very precise & I understand your explanation, let see
if I can be more precise. EX:
ID ndc units1 units2 units3
----------------------------------------
1 1 5 6 7
1 1 4 8 9
2 2 7 8 6
2 2 8 2 1
3 3 1 4 6
3 3 4 6 8
What I need is
ID ndc units1 units2 units3
----------------------------------------
1 1 5 6 7
. 1 4 8 9
2 2 7 8 6
. 2 8 2 1
3 3 1 4 6
. 3 4 6 8
The command that I used was
Duplicates drop ID, but that drop all the observations that were duplicates
not just the duplicates values in the variables ID
Let me know if that helps to understand my problem.
Best regards ---
Daniel A. Sepulveda Adams
Research Scientist - PRIME Institute
College of Pharmacy - University of Minnesota
308 Harvard ST SE, Weaver Densford Hall, 7-159
Minneapolis, MN, 55455, USA
Phone: 612-624-8489
Cell Phone: 651-295-7771
Fax: 612-625-9931
Email: [email protected]
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Nick Cox
Sent: Tuesday, August 12, 2008 12:11 PM
To: [email protected]
Subject: st: RE: Question erase duplicates values
There is no code here and no example data to be clear on what you tried.
So, how can anyone answer this except by guessing?
The fact that values of an identifier are repeated does not mean that
the dataset should be cleaned up by removing duplicates of the
identifier. That principle would wreak havoc on panel data. Cloning the
identifier makes no difference to that principle. What is true of the
original is true of the clone, necessarily.
Perhaps you did something like
. duplicates drop clonedid
And -duplicates- refused. I am very pleased to hear that. I designed
that behaviour into -duplicates- to protect people from losing
information.
Perhaps you did something else altogether, in which case please say
precisely what.
Nick
[email protected]
Daniel Sepulveda-Adams
I'm trying to created a unique ID to make a merge between two date set
But the Unique ID is a variable that have many duplicates values,
therefore
what I did was clone the variables and try to erase the duplicates
values
but just in the NEW variable but I was not able to do that. Anyone has
an
idea how to do that? Thank you for your time.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
