Please support our Computer Science and Software Design advertiser: Programming Forums
Views: 2372 | Replies: 0 | Solved
 |
•
•
Join Date: Mar 2005
Location: Nebraska, U.S.
Posts: 191
Reputation: 
Rep Power: 4
Solved Threads: 4
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:
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
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
