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

st: RE: is ordering with -bysort- unique?


From   Jose Luis Negrin Muñoz <jlnegrin@banxico.org.mx>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: is ordering with -bysort- unique?
Date   Tue, 10 Jun 2003 16:56:34 -0500

Radu,

I have used the following small program to get rid of duplicates

	sort ref;
	by ref: gen dup=_n;
	gsort ref -mesini dup;
	drop if dup>1;

where ref is a reference code and mesini is a variable related to time
(1, 2...j); these are the variables I am sorting my data by. So I will
keep only the oldest data with each particular reference code

I hope this example is useful.

José

-----Mensaje original-----
De: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] En nombre de Radu Ban
Enviado el: Martes, 10 de Junio de 2003 03:30 PM
Para: statalist@hsphsun2.harvard.edu
Asunto: st: is ordering with -bysort- unique?

dear all,

i'm cleaning a dataset and i encounter repeated ids. i want to keep them

unique, but the problem is that for some repeated ids the variables
differ. 
i want to keep just one of the repeated ids. so i'm using:

bysort id: keep if _n == 1

now i would like to know if this will keep the same id whenever the
program 
is run. or does the ordering change?

sorry for such a basic question but right now i don't have access to the

manuals.

thanks so much,

radu ban



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