title: Is there a way to get past the "too many values" error in Stata when using tabulate?
body: <p>I am trying to generate frequencies for a variable in Stata conditional on categories of another variable.</p>
  
  <p>This other categorical variable has about 790,000 observations for the category I am interested in.</p>
  
  <p>Stata's 12,000 rows and 1,200 rows limit for one-way and two-way tables respectively makes this impossible.</p>
  
  <p>Every time I run <code>tab x if y==&lt;category of interest&gt;</code> I get the following error:</p>
  
  <pre><code>too many values
  r(134);
  </code></pre>
  
  <p>I installed the <code>bigtab</code> package and though it gives me tables it cannot be used with <code>by</code> or run statistical tests.</p>
  
  <p>Is there a work around for this?</p>
  
  <p>It seems silly that Stata should have this arbitrary limit when SAS and even SPSS can run the exact same operation without trouble.</p>