title: How to create new column in PROC SQL with sum of values per month in SAS enterprise Guide?
body: <p>I have query in proc sql in SAS Enterprise Guide like below:</p>
  <pre><code>proc sql;
  select 
  event
  , mnth
  , value
  from table1
  order by mnth, name
  ;quit;
  </code></pre>
  <p>Above proc sql query gives result as below:</p>
  <pre><code>event| mnth  | value
  -----|-------|-------
  ABC  | APRIL | 3E-6
  ABC  | APRIL | 0,27950
  ABC  | APRIL | 0,556
  ABC  | MAY   | 0,228
  ...  | ...   | ...
  </code></pre>
  <p>And I need to create new column where will be showed sum of values per mnth, so as a result I need something like below <strong>(Of course we should take into account also values like '3E-6' if it is possible)</strong>:</p>
  <pre><code>event| mnth  | value   | sum
  -----|-------|---------|-----
  ABC  | APRIL | 3E-6    |
  ABC  | APRIL | 0,27950 |
  ABC  | APRIL | 0,556   | 0,8355
  ABC  | MAY   | 0,228   | 0,228
  ...  | ...   | ...     | ...
  </code></pre>
  <p>How can I modify my code in proc sql so as to achieve result like above ?</p>