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

st: RE: RE: generating new sorted ID variable


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

Another answer is to check out -qplot- from SSC.

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

Nick Cox

> 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