Return to Snippet

Revision: 36910
at November 30, 2010 06:14 by mprabhuram


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

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

Initial Description
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

Initial Title
SAS Oracle Bulk Load

Initial Tags
load

Initial Language
SAS