Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: re-sorting display order after -encode-
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: re-sorting display order after -encode-
Date
Mon, 10 Mar 2014 08:26:58 +0000
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
[email protected]
On 10 March 2014 03:01, Michael McCulloch <[email protected]>
> 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/