title: SAS PROC SQL Group by all variables to detect duplicates
body: <p>I have a dataset that contains 250 variables. I think some rows may be exact duplicates. If I only had 3 variables, I could run this code to check for dupes:</p>
  
  <pre><code>proc sql;
    create table checkDupe as
    select count(*) as N, *
    from bigTable
    group by 1, 2, 3
    having N &gt; 1;
  quit;
  </code></pre>
  
  <p>However, with 250 variables, I don't want to type out <code>group by 1, 2, 3, ... , 250</code>.</p>
  
  <p>The following <code>group by</code> statements don't work:</p>
  
  <pre><code>group by *
  
  group by _ALL_
  
  group by 1:250
  </code></pre>
  
  <p>Is there a concise way to group by all variables?</p>