topic Re: Data from SAS to Ms SQL in New SAS User

Data from SAS to Ms SQL

Citrine10 — Mon, 23 Aug 2021 10:58:32 GMT

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

Re: Data from SAS to Ms SQL

andreas_lds — Mon, 23 Aug 2021 13:36:24 GMT

@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.

Re: Data from SAS to Ms SQL

Tom — Mon, 23 Aug 2021 14:23:04 GMT

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;