libname myodbc odbc noprompt="dsn=ntauth;trusted connetcion=yes" reread_exposure=yes; proc sql; drop table myodbc.vxdtemp; quit; data myodbc.vxdemp; set myodbc.emp; run; /* give everyone 10% pay increase in the SAS table */ data sasfile(drop= sal); set myodbc.vxdemp; newsal=sal + (.10 * sal); newhiredate=Today(); run; /*update sqlserver table w/ new salary and newhiredate*/ data myodbc.vxdemp; set sasfile; modify myodbc.vxdemp (dbkey=empno cntllev=rec) key=dbkey; if _iorc_=0 then do; sal=newsal; hiredate=newhiredate; replace; end; else _error_=0; run;
... View more