How can I manipulate this data set to give a new column?
<p>I have a dataset that looks like</p>

<pre><code>ID  retailer    
1   A            
2   A               
1   B              
3   C                
3   B                
</code></pre>

<p>What I would like is a data set with a column for each distinct retailer indicating if the ID is associated with the retailer (something like a boolean would do fine).</p>

<p>I could do this manually with <code>proc sql</code> but that doesn't generalize well when I have a lot of retailers.</p>

<p>Is there anyway to create a pivot table with SAS?  I know proc tabulate can do something similar, but I need the output for further calculations.</p>

<pre><code>Desired output:

ID  A  B  C      
1   1  1  0
2   1  0  0
3   0  1  1
</code></pre>