topic SQL delete and update in SAS Procedures

SQL delete and update

chennupriya — Tue, 17 Nov 2015 15:24:20 GMT

Hi All,

I have a problem when i run a sas code it will delete the current table and insert into same table like in example below but the problem is its changing all the dates format to 1960-01-01 05:38:21.000

can anyone pls help

i have used below query

proc sql;
delete from sqldb.xy;
insert into sqldb.xy
select * from price.yz
;
quit;

Re: SQL delete and update

ballardw — Tue, 17 Nov 2015 15:45:08 GMT

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.

Re: SQL delete and update

chennupriya — Tue, 17 Nov 2015 15:49:11 GMT

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