Posted By

mprabhuram on 11/30/10


Tagged

load bulk sas


Versions (?)

SAS Oracle Bulk Load


 / Published in: SAS
 

URL: http://www.slideshare.net/mprabhuram/sas-bulk-load

use bulk load to save a large SAS dataset into oracle/DB2/SQL Server/ Teradata for joining with other tables etc..

Alternate link : http://www2.sas.com/proceedings/sugi29/106-29.pdf

  1. rsubmit;
  2. proc sql;
  3. create table DEV1.STEP_M(BULKLOAD=YES
  4. BL_DATAFILE="/home/usr/user1/BL_STEP_M_0.dat") as select * from FC.STEP_M;
  5. quit;

Report this snippet  

You need to login to post a comment.