SAS/Oracle Date Problem

Expand Post »

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:

(Toggle Plain Text)

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

stupidenator

Reputation Points: 18

Solved Threads: 4

Junior Poster

Offline

192 posts
since Mar 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Computer Science Forum Timeline: Linked list search problems

Next Thread in Computer Science Forum Timeline: Problem in Running SAS Learning Edition

DaniWeb Message

Cancel Changes

User Name
Password