Data from SAS to Ms SQL

[Citrine10]

hi there

i am looking for a Proc SQL code to transfer a table from SAS to Ms SQL.

Please assist, I can not find any code anywhere

[andreas_lds]

---

@Citrine10 wrote:

hi there

i am looking for a Proc SQL code to transfer a table from SAS to Ms SQL.

Please assist, I can not find any code anywhere

---

Then you should visit an eye specialist, i am 100% sure that code exists showing how to use insert to copy data from one dataset to another. Depending on the way the connection to ms sql is established, using proc copy could be faster.

[Tom]

Are you creating a new table in the remote database? Or appending data to an existing table?

Usually PROC APPEND is the easiest/fastest way. 

Create a libref that points to the schema in the remote database and then use PROC APPEND to copy the data.

If the target table does not exist then the FORCE option will tell SAS to create the table first.

libname mydb odbc ..... ;
proc append base=mydb.target_table data=mylib.mydataset force;
run;