06-09-2015 09:49 AM
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?
06-09-2015 09:57 AM
libname MSSQL (path=... /* your connection information */);
insert into MSSQL.DB_DATASET
select * from YOURDATASET;
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?