SAS Oracle Bulk Load


/ Published in: SAS
Save to your folder(s)

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


Copy this code and paste it in your HTML
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.