title: How can I create pivot table in SAS?
body: <p>I have three columns in a dataset: <code>spend</code>, <code>age_bucket</code>, and <code>multiplier</code>.  The data looks something like...</p>
  
  <pre><code>spend   age_bucket  multiplier
  10      18-24        2x
  120     18-24        2x
  1       35-54        3x
  </code></pre>
  
  <p>I'd like a dataset with the columns as the age buckets, the rows as the multipliers, and the entries as the sum (or other aggregate function) of the spend column.  Is there a <code>proc</code> to do this?  Can I accomplish it easily using <code>proc SQL</code>?</p>