title: Is there an efficient way of transposing huge table in SAS
body: <p>I have a data set in SAS that I need to transpose. It has the form 
  id date type value 
  and I need to convert it into 
  id date valueoftype1 valueoftype2 ...</p>
  
  <p>Is there any efficient way of accomplishing this? My data is huuuge.</p>
  
  <p>For example;</p>
  
  <pre><code>data one; 
  input ID date type $ value; 
  
  cards; 
  1 2001 A 2
  1 2002 A 4
  1 2001 B 3
  2 2001 B 1
  2 2002 A 5
  2 2002 C 2
  2 2003 C 5
  3 2001 B 6
  4 2002 B 8
  4 2003 B 4
  4 2001 A 2
  ;
  </code></pre>
  
  <p>I wish to convert it in to following form; (last three columns are valA, valB, valC)</p>
  
  <pre><code>1 2001 2 3 .
  1 2002 4 . .
  2 2001 . 1 .
  2 2002 5 . 2
  2 2003 . . 5
  3 2001 . 6 .
  4 2001 2 . .
  4 2002 . 8 .
  4 2003 . 4 .
  </code></pre>