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

[Richard Goldstein <richgold@ix.netcom.com>]

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