Advanced Search

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

Expand | Embed | Plain Text

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.