| | |
SAS/Oracle Date Problem
Please support our Computer Science advertiser: Learn about neural networks and artificial intelligence.
Thread Solved |
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
![]() |
Similar Threads
- date problem (Visual Basic 4 / 5 / 6)
- Oracle Service Problem (Oracle)
- Problem while inserting into oracle date values frm vb (Visual Basic 4 / 5 / 6)
- Dreamweaver MX2004 & date problem, etc. (Graphics and Multimedia)
- Date Problem (JSP)
- Help on SAS code (Computer Science)
Other Threads in the Computer Science Forum
- Previous Thread: Linked list search problems
- Next Thread: Problem in Running SAS Learning Edition
| Thread Tools | Search this Thread |
ai algorithm algorithms amazon assignment assignmenthelp assignments automata battery bigbrother binary bittorrent bizarre bletchleypark blogging bomb business cern codebreaker compiler computer computers computerscience computertrackingsoftware connect conversion csc dataanalysis dataintepretation development dfa dissertation dissertationthesis dissertationtopic ebook employment energy floatingpoint foreclosure foreclosuresoftware fuel gadgets geeks givemetehcodez government graphics hardware history homeowners homeworkassignment homeworkhelp humor ibm idea ideas internet iphone ipod itcontracts jobs kindle laser laws linkbait lsmeans mainframes marketing mobileapplication msaccess nano netbeans networking news os p2p piracy piratebay principles programming rasterizer research sam-being-cute sas science sex simulation software spying stephenfry study supercomputer supercomputing sweden technology textfield turing turingtest two'scompliment virus ww2





