Member Avatar for stupidenator
stupidenator 0 Junior Poster

Hi everyone,

I am still fairly new to SAS programming and I have somewhat of a problem. I am writing a program that will input a Microsoft Excel Spreadsheet and convert it to a SAS dataset. From there, I want to insert everything in that dataset into a table in an oracle database. Here is the error I am getting in the log:

ERROR: Value 12 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name.

Value 12 on the SELECT Clause is supposed to be a date. Right now, I have it as a 10 byte character type in the form mmddyyyy (e.g. 09091986). I am trying to insert this into the oracle table, into a date column but I cannot seem to figure out how to properly format the data so that it will go into the database. Any help is greatly appreciated.

Thanks,
Nick

  • 1 Contributor
  • 0 Replies
  • 94 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.