ERROR: Value n of VALUES Clause n does not match the data type
of the corresonding column in the object-item list (in the
SELECT clause)

libname x odbc dsn=yyyy user=userid pwd=passwd stringdates=yes;

proc sql;
  create table x.test(orderno int, customerno int, orderdate date);
  insert into x.test (sasdatefmt=(orderdate='date9.'))
   values(1,1,'05oct05'd);
  insert into x.test (sasdatefmt=(orderdate='date9.'))
   values(1,1,'25dec06'd);
  insert into x.test (sasdatefmt=(orderdate='date9.'))
   values(1,1,'04jul07'd);
 quit;