PROC DBLOAD Syntax / Explicit passthru statement?

[That____Redhead]

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

[RW9]

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?