title: Creating a '000s (thousands) format in SAS
body: <p>I'm trying to create a format that will convey a sense of scale for the data I'm working with.  If the number is >= 1000 I want to add <code>K</code> as a suffix, and represent it in '000s. Eg.  <code>123456</code> would be <code>123K</code>.</p>
  
  <p>This is what I have so far but clearly I'm misunderstanding something fundamental becuase the numbers going in don't look anything like the numbers coming out:</p>
  
  <pre><code>proc format;
    picture abbrev
      0              = '0'
      0     -&lt; 1000  = '000' 
      1000  - high   = '0,000,000k' (mult=.0001)
      ;
  run; 
  
  %put %sysfunc(sum(123456.0),abbrev.) /*SHOULD BE SOMETHING LIKE 123K  */
       %sysfunc(sum(12345.60),abbrev.) /*SHOULD BE SOMETHING LIKE 12.3K */
       %sysfunc(sum(1234.560),abbrev.) /*SHOULD BE SOMETHING LIKE 1.3K  */
       %sysfunc(sum(123.4560),abbrev.) /*SHOULD BE SOMETHING LIKE 123   */
       %sysfunc(sum(12.34560),abbrev.) /*SHOULD BE SOMETHING LIKE 12    */
       %sysfunc(sum(1.234560),abbrev.) /*SHOULD BE SOMETHING LIKE 1     */
       ;
  </code></pre>