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   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:29:52 -0800 (PST)

Wow, so many different solutions. This works exactly as I needed. Thanks
for your help!

-jeff

--- David Radwin <[email protected]> wrote:

> Jeff,
> 
> You could use Paul H. Bern's program -bigtab-, available from SSC.
> 
> . ssc install bigtab
> 
> David
> 
> At 11:56 AM -0800 1/16/08, 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
> >
> >
> > 
>
>____________________________________________________________________________________
> >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/
> 
> 
> -- 
> David Radwin, Principal Analyst // [email protected]
> Office of Student Research, University of California, Berkeley
> *
> *   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/
> 



      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

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