Trying to loading sas dataset into oracle table; problems with proc append

lam1 — Wed, 15 Aug 2018 19:12:44 GMT

Hi,

I have code that works loading & appending a sas data set into oracle table using my 32 bit machine. Just got a new 64 bit machine and now I get errors with the same code.

Errors: SQL*Loader utility failed to execute reasons like not installed; trouble creating log file;remove any double sets of quotes.

I got some other code but I'm having problems with it. I stopped it as it

was going on and on.

Oracle table=TEST_CONSULTS_GA (5 field names)

gamonth is sas data set I want to load with only 181 records;

SAS9.4

Thank you in advance for any help.

80
81
82 libname ora oracle path="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST =
82 ! scan-szaddb74.ssdc.kp.org)(PORT = 1521))
83 (CONNECT_DATA = (SERVICE_NAME=ARIRDRA_CMI)))" user = "cmimu_t" password
83 ! = XXXXXXXXX;
NOTE: Libref ORA was successfully assigned as follows:
Engine: ORACLE
Physical Name: (DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST =
scan-szaddb74.ssdc.kp.org)(PORT = 1521)) (CONNECT_DATA =
(SERVICE_NAME=ARIRDRA_CMI)))
84
85 Proc Append BASE = ORA."TEST_CONSULTS_GA"n(DBCOMMIT=4000
NOTE: Writing HTML Body file: sashtml2.htm
86 DBFORCE = YES
87 BULKLOAD=YES
88 BL_BADFILE='ora.TEST_CONSULTS_GA.bad'
89 BL_SQLLDR_PATH= 'C:\orant\Ora12\BIN\sqlldr'
90 BL_DATAFILE='C:\users\u937411\test\gamonth.dat'
91 BL_CONTROL='C:\users\u937411\ga.ctl'
92 BL_LOAD_METHOD = Truncate
93 BL_RECOVERABLE = NO
94 BL_OPTIONS = 'PARALLEL=TRUE'
95 BL_LOG= '\gamonth.log) force;
96 run;
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE APPEND used (Total process time):
real time 15:40.53
cpu time 4.09 seconds

Re: Trying to loading sas dataset into oracle table; problems with proc append

SuryaKiran — Wed, 15 Aug 2018 20:05:13 GMT

When your using BULKLOAD control, log and data files will be created by default to current directory. Make sure you have write access or specify the right path.

For more information check these: http://support.sas.com/kb/51/802.html

http://support.sas.com/resources/papers/proceedings13/072-2013.pdf In this paper check Bulk Load processing sub-heading

topic Trying to loading sas dataset into oracle table; problems with proc append in SAS Programming

Trying to loading sas dataset into oracle table; problems with proc append

Re: Trying to loading sas dataset into oracle table; problems with proc append