SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

PROC DBLOAD Syntax / Explicit passthru statement?

Reply
Contributor
Posts: 25

PROC DBLOAD Syntax / Explicit passthru statement?

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

Super User
Super User
Posts: 7,401

Re: PROC DBLOAD Syntax / Explicit passthru statement?

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?

Ask a Question
Discussion stats
  • 1 reply
  • 213 views
  • 0 likes
  • 2 in conversation