topic Re: Insert data in SQL server table in SAS Programming

Insert data in SQL server table

Babloo — Tue, 13 Aug 2019 01:04:59 GMT

I have table in SQL server and I have one SAS WORK data set. Both are similar structure with same data type.

Now I would like to know the different ways to insert SAS dataset observation in SQL table from SAS.

Is below code the right way to insert records in SQL server table?

e.g.

Proc append data=sqllibrary.table data=sas_work_dataset force;
Run;

Re: Insert data in SQL server table

SASKiwi — Tue, 13 Aug 2019 01:47:29 GMT

PROC APPEND is the easiest way to insert new rows into an external database table. Have you tried it?

Re: Insert data in SQL server table

Reeza — Tue, 13 Aug 2019 15:03:10 GMT

PROC APPEND is one of the fastest because it's just a proc to move data, a data step or SQL procedure can also be used to transform data so it copies data line by line. APPEND copies data in blocks.

I'm assuming you have the bulkload option set up as well on your server connection.

@Babloo wrote:
I have table in SQL server and I have one SAS WORK data set. Both are similar structure with same data type.

Now I would like to know the different ways to insert SAS dataset observation in SQL table from SAS.

Is below code the right way to insert records in SQL server table?

e.g.

Proc append data=sqllibrary.table data=sas_work_dataset force;
Run;