Martin, thank you very much!
I undertand now.
Best regards,
Rose
----- Original Message -----
From: Martin Weiss <[email protected]>
To: <[email protected]>
Subject: RE: st: RE: Is there a command similar to "bys" if I want to gsort the variables?
Date: 2009-12-4 14:08:11
<>
"...why did the result of "d, short" in your typing show it was sorted by
order, not year area?"
As [D], p. 260 says: " Stata ... does not understand descending sorts (gsort
is an ado-file). To
remedy this problem, gsort's generate() option will create a new grouping
variable that is in
ascending order (thus satisfying Stata's narrow definition) and that is, in
terms of the groups it defines,
identical to that of the true sort variables"
HTH
Martin
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of [email protected]
Sent: Freitag, 4. Dezember 2009 04:32
To: statalist
Subject: Re: st: RE: Is there a command similar to "bys" if I want to gsort
the variables?
Austin, Eric,and Kieran,Thank you very much for your replies.
I just want to make it easy when I want to arrange observations to be in
descending order of the specified variables and do something else
following.
Just like "bys z1 z2: g num=_n" (this is just an example.)
Anyway,thank you for your help.
Kieran, why did the result of "d, short" in your typing show it was sorted
by order, not year area?
d, short
Contains data
obs: 17
vars: 3
size: 221 (99.9% of memory free)
Sorted by: order
Note: dataset has changed since last saved
Thank you for any help.
Best regards
Rose
----- Original Message -----
From: Kieran McCaul <[email protected]>
To: <[email protected]>
Subject: st: RE: Is there a command similar to "bys" if I want to gsort the
variables?
Date: 2009-12-4 05:05:13
...
Is this what you want?
input year area
2000 1
2000 1
2000 2
2000 2
2001 1
2001 2
2001 3
2001 3
2001 3
2001 4
2002 2
2002 2
2002 4
2003 3
2003 3
2003 6
2003 6
end
gsort year -area, gen(order)
list
d, short
by order:gen num=_n
list
______________________________________________
Kieran McCaul MPH PhD
WA Centre for Health & Ageing (M573)
University of Western Australia
Level 6, Ainslie House
48 Murray St
Perth 6000
Phone: (08) 9224-2701
Fax: (08) 9224 8009
email: [email protected]
http://myprofile.cos.com/mccaul
http://www.researcherid.com/rid/B-8751-2008
______________________________________________
If you live to be one hundred, you've got it made.
Very few people die past that age - George Burns
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: Thursday, 3 December 2009 11:55 PM
To: statalist
Subject: st: Is there a command similar to "bys" if I want to gsort the
variables?
Dear statalists,
Is there a command similar to "bys" if I want to gsort the variables?
For example,
bys year (area): g num=_n
However, I want to gsort the variable of area.
I have tried as followings,
gsort year -area
by year: g num=_n
Is there an easier way to do it just like -bys-?
By the way, when I typed "d,short" after I typed "gsort year -area", the
result was as followings,
Contains data from study.dta
obs: 155
vars: 6 5 Jun 2009 01:45
size: 3,875 (99.9% of memory free)
Sorted by: year
Why the sorted variable did not contain area?
Thank you for any help!
Best regards,
Rose
*
* 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/
*
* 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/
*
* 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/
