By any chance is any of this data in another database such as Oracle, DB2 or SQL server?
There are a lot of systems out there that say something is a "date" but is actually a datetime. The specific value you show makes me beleive that you actually have a date, 08/01/2015, as a value being inserted into something that is expecting a datetime value.
yes you are rite but for first time its working fine and loading correct dates i mean
PROC SQL; CREATE TABLE sqldb.xy AS SELECT FROM price.yz; quit;
/*inorder to update table in sql */
proc sql; delete from sqldb.xy; insert into sqldb.xy select * from price.yz ; quit;
for the first time ia m using proc sql create table in sql but once the table is created in sql then when i run second time i am just deleteing table and inserting rows into same table but when i am doing secong procedure teh dtae format changes pls explain
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.