BookmarkSubscribeRSS Feed
That____Redhead
Fluorite | Level 6

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

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 757 views
  • 0 likes
  • 2 in conversation