Help using Base SAS procedures

Load odbc temp table with sas dataset

Reply
Regular Contributor
Regular Contributor
Posts: 166

Load odbc temp table with sas dataset

Hi All,

I use a libname statement to connect to an  odbc .

libname mycc odbc datasrc=myodbc user=myuser password= mypassword;

next i create a temp table in the odbc server using a sas dataset

slow...

poc sql;

create table mycc.'#table1'n  as select customer_id from work.sas_table; quit;

The poblem i face is that odbc temp table gets loaded at a speed of 1000 rows a minute.. which is too slow..

any suggestions on how i could increase the loading speed..

Thanks...

Super User
Posts: 3,254

Re: Load odbc temp table with sas dataset

Try adding the INSERTBUFF = option to your LIBNAME. The default value for ODBC is only 1 according to the documentation, that is one row at a time. You may have to experiment to get the optimal value, but I suggest you try values like  500 or 1000. You may also be restrained by the DBCOMMIT = option where usually the default is 1000. Setting this to 0 means only one commit is made at the end of the load, and this may well help also.

Ask a Question
Discussion stats
  • 1 reply
  • 199 views
  • 1 like
  • 2 in conversation