title: Assigning values to the relevant column sas macro
body: <p>num...name...cost...ab...ac...ad...ae</p>
  
  <p>1..........ac.......40<br>
  2..........ab.......10<br>
  3..........ae.......30<br>
  4..........ad.......20              </p>
  
  <p>Hi i'm very new in sas macro and i need help assigning cost values to the relevant column like this.</p>
  
  <p>Could you please help me?                       </p>
  
  <p>num...name...cost...ab...ac...ad...ae</p>
  
  <p>1........ac.........40..........40<br>
  2........ab.........10....10<br>
  3........ae.........30  ........................30</p>
  
  <p>4........ad.........20.................20   </p>