title: divide data into groups in SAS proc-sql
body: <p>I need to create some cycle in SAS proc-sql which divide data into groups. 
  I have data</p>
  
  <pre><code>ID1     ID2 TIME                    GROUP
  1234    12  22MAY2015:16:10:00.000  0
  1234    12  22MAY2015:16:15:00.000  0
  1234    12  12JUN2015:6:35:00.000   0
  1234    12  12JUN2015:16:35:00.000  0
  6549    45  15APR2015:16:10:00.000  0
  6549    45  18APR2015:13:15:00.000  0
  6549    45  18APR2015:13:18:00.000  0
  6549    15  22MAY2015:14:15:00.000  0
  6549    15  22MAY2015:14:20:00.000  0
  </code></pre>
  
  <p>and I need create new column GROUP where will be the same id for those rows which have same ID1, same ID2 and difference between TIME is max 10 minutes. </p>
  
  <p>Result will be:</p>
  
  <pre><code>ID1     ID2 TIME                    GROUP
  1234    12  22MAY2015:16:10:00.000  1
  1234    12  22MAY2015:16:15:00.000  1
  1234    12  12JUN2015:6:35:00.000   2
  1234    12  12JUN2015:16:35:00.000  3
  6549    45  15APR2015:16:10:00.000  4
  6549    45  18APR2015:13:15:00.000  5
  6549    45  18APR2015:13:18:00.000  5
  6549    15  22MAY2015:14:15:00.000  6
  6549    15  22MAY2015:14:20:00.000  6
  </code></pre>
  
  <p>I have tried to write some 'do while' cycle but it does not work.</p>
  
  <pre><code>data b;
  set a;
  time1 = time;
  id1_1 = id1;
  id2_1 = id2;
  time2 = time;
  id1_2 = id1;
  id2_2 = id2;
  group = group+1;
  do while (id1_1 eq id1_2 id2_1 eq id2_2 floor((time2-time1)/60)&lt;=10);
  group = group;
  time2 = time;
  id1_2 = id1;
  id2_2 = id2;
  end;
  run;
  </code></pre>
  
  <p>Thank you very much.</p>