Statalist


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

Re: st: Using tab command on strings, exceeding 65,536 limit


From   Richard Goldstein <[email protected]>
To   [email protected]
Subject   Re: st: Using tab command on strings, exceeding 65,536 limit
Date   Wed, 16 Jan 2008 15:19:52 -0500

-codebook- will tell you how many unique values Stata thinks there are (or you could download -unique- via -findit-)

the max number of rows for tabulate depends on your version of Stata; see -help limits-

Rich

Jeff Simonson wrote:

Hello,

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.
Any suggested work-arounds would be helpful.

Thanks,
Jeff
*
*   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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index