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

st: RE: generating new sorted ID variable


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: generating new sorted ID variable
Date   Tue, 2 Dec 2003 18:57:16 -0000

The sorted ids can be got with 

egen SortedID = group(X ID) 

although it's possible that the variant 
-egroup()- in -egenmore- on SSC may be 
closer to what you want. 

How does the graph you want with -twoway bar- 
differ from what you can get with 

graph bar response, over(id, sort(1)) 

Nick 
n.j.cox@durham.ac.uk 

Pagan, jose
 
> I have a variable called ID that goes from 1 through 60, and an X
> variable that takes the same value within each ID value (I have an
> unbalanced panel of about 50,000 obs). I want to create a new ID
> variable that is sorted in ascending or descending order by 
> X so that I
> can do a sorted twoway bar graph. Or, better byyet, is there 
> a way to sort
> twoway bar or rspike graphs? Sorted graphs seem to be an option for
> 'graph bar' but not for 'twoway bar'. Thanks for your help, Jose.  
> 
> For example: 
> 
> ID	X	SortedID or SortedID
> 1	4	2			2
> 1	4	2			2
> 1	4	2			2
> 2	7	1			3
> 3	2	3			1
> 3	2	3			1

*
*   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