title: SAS-How to format arrays dynamically based on information in one column
body: <p>I'm new to SAS, and would greatly appreciate anyone who can help me formulate a code. Can someone please help me with formatting changing arrays based on the first column values?</p>
  
  <p>So basically here's the original data:</p>
  
  <pre><code>  Category     Name1    Name2.........  (Changes invariably)
  
    #ofpeople     20       30
    #ofproviders  10       5 
    #ofclaims     40       25
    AmountBilled  50       100
    AmountPaid    11       35
    AmountDed     5        6 
  </code></pre>
  
  <p>I would like to format the values under Name1 to infinite Name# and reformat them to dollar10.2 for any values under Category called 'AmountBilled','AmountPaid','AmountDed'.</p>
  
  <p>Thank you so much for your help!</p>