title: SAS insert value with proc sql
body: <p>So I have a rather interesting problem. I am trying to insert a current date in specific formats and styles, but for some reason it seems to fail. I know its not a formatting issue... But idk how to fix it. a data step solution is welcomed as well... Here's what works.</p>
  
  <pre><code>proc sql;
  create table work.test
  (test_Id char(50), test_Name char(50), cur_Mo char(1), cur_Qtr char(1), entered_Date char(8));
  insert into work.test 
  values('201703','2017 Mar','0','0','24APR17')
  values('201704','2017 Apr','0','0','24APR17')
  values('201706','2017 Jun','1','0','23JUN17');
  quit;
  </code></pre>
  
  <p>Here's what doesn't:</p>
  
  <pre><code>proc sql;
      insert into work.test 
      values(catx('',put(year(today()),4.),case when month(today())&lt; 10 then catx('','0',put(month(today()),2.)) else put(month(today()),2.)end) ,catx(' ',[put(year(today()),4.),put(today(),monname3.))],'1','0',put(today(),date7.));
  quit;
  </code></pre>