Thank you to all those who responded. I realise that what I want to do is bit unusual, but there is reason for that - I want to compare the original variable and the reordered one, with respect to another variable. Thank you for the cautions though, and for the suggestions which have solve my problem.
PS -reorder- was mentioned in a previous Statalist posting, http://www.stata.com/statalist/archive/2004-08/msg00873.html
thanks again,
Cindy
----- Original Message ----
From: David Airey <[email protected]>
To: [email protected]
Sent: Friday, 1 August, 2008 4:26:02 PM
Subject: Re: st: reordering observations
.
If merge is not your thing, export to Microsoft Excel or any
spreadsheet. Sort just that column. Import to Stata.
:)
On Aug 1, 2008, at 8:43 AM, Cindy Gao wrote:
> Hello,
>
> I need to reorder one of my variables (from lowest to highest)
> without changing the order of other variables in my dataset. Is
> there any simply way to do this?
>
> Like, I have now:
> var1 var2 var3 ...
> 3 7 9
> 2 10 3
> 7 8 5
> ..........
>
> And I like to reorder var3 to get:
> var1 var2 var3 ...
> 3 7 3
> 2 10 5
> 7 8 9
> ..........
>
> Please, this is not the -reorder- command which is already there in
> Stata, it is something different.
>
> Many thanks!
> Cindy
>
>
>
> __________________________________________________________
> Not happy with your email address?.
> Get the one you really want - millions of new email addresses
> available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
>
>
> *
> * 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/
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
*
* 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/