PROC DBLOAD Syntax / Explicit passthru statement?

That____Redhead — Tue, 09 Jun 2015 13:49:00 GMT

Hello,

I have an ongoing scoring process where I need to load updated scores monthly to an MS/SQL Server table, and just want to append to the table. PROC DBLOAD is having issues; is there any way to write an explicit passthru statement in PROC SQL to do this?

Thanks!

--Russell

Re: PROC DBLOAD Syntax / Explicit passthru statement?

RW9 — Tue, 09 Jun 2015 13:57:35 GMT

Hi,

libname MSSQL (path=... /* your connection information */);

proc sql;

insert into MSSQL.DB_DATASET

select * from YOURDATASET;

quit;

Assumes that the YOURDATASET matches the DB_DATASET. Also note you could get duplicates and other issues. Personally I always recommend doing the database part on the database end rather than from another application, you wouldn't for instance, send your email replies from Excel would you?

topic Re: PROC DBLOAD Syntax / Explicit passthru statement? in SAS Data Management

PROC DBLOAD Syntax / Explicit passthru statement?

Re: PROC DBLOAD Syntax / Explicit passthru statement?