Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: sorting with tabdisp


From   Maarten buis <maartenbuis@yahoo.co.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: sorting with tabdisp
Date   Tue, 5 Feb 2008 20:36:52 +0000 (GMT)

--- Thomas <tpt21@cam.ac.uk> wrote:
> thanks but I guess I expressed myself badly:
> 
> In
> 
> tabdisp name yr, cellvar(var)
> 
> I want to order name (i.e. the rows) according to the values
> of cellvar in the first column.

I think my understanding of the problem was off but my solution
correct: you need to use the -axis()- function in -egenmore-
(downloadable from -ssc-), see the example below:

*--------------- begin example -------------------------
sysuse auto, clear
recode rep78 1/2=3

// This creates a variable manifacturer
// I use this variable because this type of ordering
// makes most sense when you have a categorical variable
gen manif = word(make,1)

contract manif rep78
bys manif (rep78) : gen order = _freq[1] if rep78 == 3
bys manif (rep78) : replace order = order[1]
replace order = 0 if order == .
egen Manif = axis(order manif), label(manif)
tabdisp Manif rep78, cellvar(_freq)
*--------------- end example ---------------------------
(For more on how to use examples I sent to the Statalist, see
http://home.fsw.vu.nl/m.buis/stata/exampleFAQ.html )

Hope this helps,
Maarten

-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands

visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434

+31 20 5986715

http://home.fsw.vu.nl/m.buis/
-----------------------------------------


      __________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com

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