title: Insert into function with SAS/SQL
body: <p>I want to insert values into a new table, but I keep getting the same error: VALUES clause 1 attempts to insert more columns than specified after the INSERT table name. This is if I don't put apostrophes around my date. If I do put apostrophes then I get told that the data types do not correspond for the second value.</p>
  
  <pre><code>    proc sql;
      create table date_table
      (cvmo char(6), next_beg_dt DATE);
      quit;
  
      proc sql;
        insert into date_table 
      values ('201501', 2015-02-01)
      values ('201502', 2015-03-01)
      values ('201503', 2015-04-01)
      values ('201504', 2015-05-01);
      quit;
  </code></pre>
  
  <p>The second value has to remain as a date because it used with > and &lt; symbols later on. I think the problem may be that 2015-02-01 just isn't a valid date format since I couldn't find it on the SAS website, but I would rather not change my whole table. </p>