How can I create pivot table in SAS?
<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>