title: PROC Trasnpose/query builder in SAS Enterprise Guide
body: <p>After I run Transpose in query builder, i get '.' for empty fields. Is there a way to avoid these '.' ? I can remove those in the next step by adding a case statement but doing this for more than 100 columns won't be a good idea.</p>
  
  <pre><code>123019  1   .   .   .
  166584  .   1   .   .
  171198  .   .   1   .
  285703  .   .   .   1
  309185  .   .   .   2
  324756  .   .   .   1
  335743  .   .   .   .
  348340  .   .   .   .
  </code></pre>
  
  <p>Please help.</p>
  
  <p>Thanks</p>