title: Format Comma10.2 or Dollar10.2 in SAS
body: <p>I have a question on format in SAS. Below is my code</p>
  
  <pre><code>PROC SQL;
  CREATE TABLE OUT.FIN_POP_4a AS
  SELECT sum(CORR_AM) as correction_am 
      FROM OUT.FIN_POP_4
  ;
  QUIT;
  </code></pre>
  
  <p>correction_am is format numeric 8. How do I change this to Comma10.2 or Dollar10.2 in SAS in data step or proc sql code? I have tried various methods that did not work. </p>
  
  <p>I have tried below code which worked but did not retain the two decimal places.</p>
  
  <pre><code>PROC SQL;
      CREATE TABLE OUT.FIN_POP_4a AS
      SELECT sum(CORR_AM) as correction_am format comma10.
          FROM OUT.FIN_POP_4
  ;
  QUIT;
  </code></pre>