please check this post
https://communities.sas.com/t5/SAS-Procedures/Uploading-data-to-SQL-server-issue-with-Date-variable/m-p/172158#M44397
I have the same problem as the dates coverting to 1960 when updating a table in sql server from sas
pls help me
... View more
Loading SAS Date into SQL server. - Google Groups
I'm trying to load SAS date(format DATE9.,informat 8 int) into sql server database DATE column using ODBC connection. libname xxx ODBC DSN=xxxxxx bulkload=yes ; proc sql; INSERT into sqldb.tablename select * from xy.sales; quit; ERROR: Value 1 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name.
my sas date format is MMDDYY10. I appreciate any help on this. Thanks.
... View more
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
... View more
Hi ,
Could you pls explain the code for option 2 . actually I have used below code but when i am using this its chaging teh date format
pls explain how to do it
proc sql; delete from sqldb.xy; insert into sqldb.xy select * from price.yz ; quit;
... View more
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;
... View more
Hi
Sorry I couldnt understand what u have said . Below is the link i am using to create a bat file . Pls help me if i am wrong
"C:\Program Files\sashome\SASFoundation\9.4\sas.exe" -SYSIN "C:\test1.sas -LOG "C:\test1.log" -PRINT "C:\test1.lst"
... View more
i did the same way but i get an error which is indicated below .Pls help
ERROR: Unrecognized SAS option name :\Jack_cash\SAMPLECODE.LOG". ERROR: (SASXKRIN): KERNEL RESOURCE INITIALIZATION FAILED. ERROR: Unable to initialize the SAS kernel
... View more
Hi I have a sas program which updates a table in sql server everytime i run the sas code in base sas 9.4 . But that code need to be run weekly and mine is desktop sas and i need to schedule the job using windows task scheduler . Can anyone pls help
how is the process as i have no idea about it
Thanks
... View more
how to write a code so that it will update the sql table in sql server when i run sas code both sas dataset and sql table will have same variables but in sas dataset which i run everymonth will have any changes in old records and new records
can u pls let me know how to write the code
Thanks
... View more
Hi
I have a sas dataset finalxyz so its has data from aug2014 to aug2015 now and if i run next month it will have sep2015 records
and using libname i have loaded that table into sql server but every month we get records for new months so there is a way that if i run sas code the table would get updated automatically with new records in sql ?. Can anyone pls help
Thanks
... View more
HI i just want to check the variables in two different tables in two different databases like one in production and one in test( development ) . Is there any procedure in Sas and also procedure in SQL . Can anyone help
... View more
HI, i have a code I should the records which has only those vendors names but I have 30 vendor names and I don't want to type all those vendor names so is there any way . keeping all those 30 vendor names in excel and can call it using macro . Any idea ?? Pls help
... View more
HHi i have below values which I got in SAS . I need to convert those values . 8206830622.6 value to 8,206,830,623 -74661564.97 to (74,661,564) 19.682897626 - 19.68290 0.0005251792 to 0.1% can anyone pls help
... View more
hi , i have used Datdif function and intik also but I am getting negative -28 i mean dates cant be negative so. I want to avoid negative sign . Can anyone help
... View more
