 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Using tab command on strings, exceeding 65,536 limit
|
From |
Jeff Simonson <[email protected]> |
|
To |
[email protected] |
|
Subject |
Re: st: Using tab command on strings, exceeding 65,536 limit |
|
Date |
Wed, 16 Jan 2008 13:28:08 -0800 (PST) |
Your suggestion works. Thank you!
-Jeff
--- Svend Juul <[email protected]> wrote:
> Jeff wrote:
>
> I am using Stata 9 and want to get a simple tabulation by city. My file
> consists of over 207,000 rows. When I type in "tab city" I get returned
> an
> error R134 that warns me that I cannot encode more than 65,536 unique
> values. When I do a select distinct sql statement in my Access table on
> the same field there are only 3046 unique values.
>
> ------------------------------------------------------------------------
>
> The full explanation to r(134) reads:
>
> [P] error . . . . . . . . . . . . . . . . . . . . . . . . Return
> code 134
> too many values;
> (1) You attempted to encode a string variable that takes on more
> than 65,536 unique values. (2) You attempted to tabulate a
> variable
> or pair of variables that take on too many values. If you
> specified two variables, try interchanging the two variables.
> (3) You issued a graph command using the by option. The
> by-variable
> takes on too many different values to construct a readable
> chart.
>
> Your problem is not with (1) -encode- but with (2) -tabulate-.
>
> To get the table desired, you could:
>
> generate x=1
> sort city
> collapse (sum) x, by(city)
> list
>
> Hope this helps
> Svend
>
> ________________________________________________________
>
> Svend Juul
> Institut for Folkesundhed, Afdeling for Epidemiologi
> (Institute of Public Health, Department of Epidemiology)
> Vennelyst Boulevard 6
> DK-8000 Aarhus C, Denmark
> Phone, work: +45 8942 6090
> Phone, mobile: +45 2634 7796
> Fax: +45 8613 1580
> E-mail: [email protected]
> _________________________________________________________
>
> *
> * 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/
>
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
*
* 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/