the following code runs successfully when I'm inside the job
https://server-name/SASJobExecution
but fails to create those tables that pull from reffile and from the db connector when I schedule the job..
options cashost="xxxxxxxxx.xxxx.es" casport=5570;
cas;
caslib _all_ assign;
OPTIONS VALIDVARNAME=ANY;
proc casutil;
droptable casdata="testus" incaslib="mkt" quiet;
droptable casdata="_FC5PTOS" incaslib="mkt" quiet;
droptable casdata="_DIM_CONCESIONARIOS" incaslib="mkt" quiet;
run;
data mkt.testus(promote=yes);
set risknoba.the_sales;
run;
LIBNAME myora ORACLE PATH=VWFSES1P USER=SAS PASSWORD='xxxxxxxxx';
data mkt._DIM_CONCESIONARIOS(promote=yes);
set myora.DIM_CONCESIONARIOS;
run;
FILENAME REFFILE '/caslibs/marketing/FC5PTOS.TXT' encoding=latin1;
data mkt._FC5PTOS(promote=yes) ;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile REFFILE delimiter = ';' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat OPERACION $12. ;
informat NUMCUOTA best32. ;
informat NOMINAL commax9.2 ;
informat "CAP. PENDIENTE"N commax9.2 ;
informat "IMP. RECOMPRA CONCE"N commax9.2 ;
informat "PTOS. MES"N commax9.2 ;
informat "TOT. PUNTOS"N commax9.2 ;
informat "PTOS. EXTRA"N commax9.2 ;
informat "TOT. PTOS EXTRA"N commax9.2 ;
informat VAR10 $1. ;
format OPERACION $12. ;
format NUMCUOTA best12. ;
format NOMINAL commax9.2 ;
format "CAP. PENDIENTE"N commax9.2 ;
format "IMP. RECOMPRA CONCE"N commax9.2 ;
format "PTOS. MES"N commax9.2 ;
format "TOT. PUNTOS"N commax9.2 ;
format "PTOS. EXTRA"N commax9.2 ;
format "TOT. PTOS EXTRA"N commax9.2 ;
format VAR10 $1. ;
input
OPERACION $
NUMCUOTA
NOMINAL
"CAP. PENDIENTE"N
"IMP. RECOMPRA CONCE"N
"PTOS. MES"N
"TOT. PUNTOS"N
"PTOS. EXTRA"N
"TOT. PTOS EXTRA"N
VAR10 $
;
if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
run;
