title: Partitioned Running Totals in SAS
body: <p>How can I create a new column for an existing dataset that is the running total of an existing column - partitioned by some identifier?</p>
  
  <pre><code>ID |  Value |     New Value
  ---|--------|--------------------
  1  |   10   |     10
  1  |   5    |     15  = 10 + 5
  1  |   3    |     18  = 10 + 5 + 3
  2  |   45   |     45
  2  |   15   |     60  = 45 + 15
  </code></pre>
  
  <p>I'm used to accomplishing this in SQL (Oracle) with a simple SUM() OVER() statement, but that syntax is apparently not supported in PROC SQL.  </p>
  
  <p>If possible, I would like to accomplish this within PROC SQL (I am much more experienced with SQL than SAS coding).</p>
  
  <p>Thanks!</p>
  
  <p>Mike.</p>