topic Bulkload = option in SAS Programming

Bulkload = option

GeorgeSAS — Fri, 07 Jun 2019 17:01:59 GMT

Hello everyone,

Can I download Oracle table to local SAS with bulkload option? looks It can only upload.

libname orausr oracle path=xxxxxx authdomain='xxxxxxx';

*----this looks work;
data orausr.zips (bulkload=yes);
    set sashelp.zipcode;
run; 
*------------end--;




*----this not work,ERROR 22-7: Invalid option name BULKLOAD.
data need(bulkload=yes);
set orausr.zips;
run;

*------end;

Thanks!

Re: Bulkload = option

LinusH — Fri, 07 Jun 2019 22:15:48 GMT

You are correct. Bulkload is for external databases.
Performance wise, loading a SAS dataset shows similar (sometimes even better) performance as bulkoafing a database.

Re: Bulkload = option

SASKiwi — Fri, 07 Jun 2019 23:04:34 GMT

As the name of the option suggests it is for table loading only.

Re: Bulkload = option

GeorgeSAS — Mon, 10 Jun 2019 18:15:45 GMT

Is there any availability of corresponded downloading option?

Re: Bulkload = option

SASKiwi — Mon, 10 Jun 2019 20:36:46 GMT

If you are trying to improve the performance of read queries then you could try the READBUFF option which can be set as high as 32767 (32K). You will need to experiment with different values to see what works best, if it has any impact at all.