Insert data in SQL server table

[Babloo]

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;

[SASKiwi]

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

[Reeza]

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;

---