title: converting to_char in sql to sas (proc sql)and format date
body: <pre><code>proc sql outobs=100;
  select
     to_char(b.cre_date,'YYYY-MM-DD') as CDate,**
     b.sub_id,
     c.subs_name,
  
  
  quit;
  </code></pre>
  
  <p>I am trying to run the above code in sas eg..but I am unable to use the to_char function in proc sql.
  the logic is I need to format cre_date as yyyy-mm-dd the present date is in datetime25.6 informat. and also suggest me a replacement for to_char in proc sql</p>
  
  <p>thanks,</p>