Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Michael McCulloch <mm@pinestreetfoundation.org> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: re-sorting display order after -encode- |
Date | Mon, 10 Mar 2014 12:09:37 -0700 |
Thanks Nick! Best wishes, Michael McCulloch -- Pine Street Foundation, since 1989 124 Pine Street | San Anselmo | California | 94960-2674 P: (415) 407-1357 | F: (206) 338-2391 | http://www.PineStreetFoundation.org On Mar 10, 2014, at 1:26 AM, Nick Cox wrote: > You evidently just used the default produced by -encode- so that > incoming strings were labelled according to their alphanumeric order. > Thus values 1, 2, 3, 4, 5 correspond to strings "0-200" ... > "501-1,000". -encode- has no notion of looking inside the strings to > discern a meaning and thus a natural order, any more than than it can > sort "average" "bad" "good" into the correct order. You need to define > labels in advance before you use -encode- or fix the problem using > -recode- or some equivalent. > > Nick > njcoxstata@gmail.com > > > On 10 March 2014 03:01, Michael McCulloch <mm@pinestreetfoundation.org> > >> I have used -encode- to add value labels from string variable, which are a series of numerical ranges stored as text. >> >> -codebook- shows the frequency data, and Label values, were correct. >> Freq. Numeric Label >> 121 1 0-20 >> 16 2 1,001+ >> 36 3 101-500 >> 81 4 21-100 >> 8 5 501-1,000 >> >> However, I wish to display them using -tab- so that the rows are sorted on the value label. >> The -encode- help file does not suggest this is possible. Is there a workaround? >> >> What I want to achieve is -tab- showing this: >> Label Freq >> 0-20 121 >> 21-100 81 >> 101-500 36 >> 501-1,000 8 >> 1,001+ 16 > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/