Error while working with SAS datasets

[srinagesh]

Hi !

I am new to SAS connectivity with datastage.

I have developed a small job (New Parallel Job using Datastage Server Edition 7.5.1A) to create a SAS dataset and am encountering this error.

Please help me with this


-Nagesh
===================================
SAS_13,0: Program '/usr/sas/SAS_9.1/sas/sas' was not found in PATH '/datastage/Projects/SCDWTechDev/RT_BP1127.O:/datastage/Projects/SCDWTechDev/wrapped:/datastage/Projects/SCDWTechDev/buildop:/opt/dsSoftware/Ascential/DataStage/DSCAPIOp:/opt/dsSoftware/Ascential/DataStage/RTIOperators:/opt/dsSoftware/Ascential/DataStage/DSParallel:/opt/dsSoftware/Ascential/DataStage/PXEngine/user_osh_wrappers:/opt/dsSoftware/Ascential/DataStage/PXEngine/osh_wrappers:/usr/local/bin:/usr/reg-central/bin:/usr/central/bin:/usr/reg-common/scripts:/usr/common/scripts:/usr/openwin/bin:/usr/dt/bin:/opt/SUNWspro/bin:/usr/bin:/usr/ucb:/usr/ccs/bin:/opt/dsSoftware/Ascential/DataStage/PXEngine/bin:/local/app/oracle/product/9.2.0.6/bin:/opt/dsSoftware/Ascential/DataStage/PXEngine/bin:/local/app/oracle/product/9.2.0.6/bin:/bin'; exec() may fail.


SAS_13,0: ##E TFSU 000166 11:48:53(001) <main_program> unable to invoke program '/usr/sas/SAS_9.1/sas/sas': No such file or directory. Make sure the program exists, is executable, and is on the search path. The current PATH is: /datastage/Projects/SCDWTechDev/RT_BP1127.O:/datastage/Projects/SCDWTechDev/wrapped:/datastage/Projects/SCDWTechDev/buildop:/opt/dsSoftware/Ascential/DataStage/DSCAPIOp:/opt/dsSoftware/Ascential/DataStage/RTIOperators:/opt/dsSoftware/Ascential/DataStage/DSParallel:/opt/dsSoftware/Ascential/DataStage/PXEngine/user_osh_wrappers:/opt/dsSoftware/Ascential/DataStage/PXEngine/osh_wrappers:/usr/local/bin:/usr/reg-central/bin:/usr/central/bin:/usr/reg-common/scripts:/usr/common/scripts:/usr/openwin/bin:/usr/dt/bin:/opt/SUNWspro/bin:/usr/bin:/usr/ucb:/usr/ccs/bin:/opt/dsSoftware/Ascential/DataStage/PXEngine/bin:/local/app/oracle/product/9.2.0.6/bin:/opt/dsSoftware/Ascential/DataStage/PXEngine/bin:/local/app/oracle/product/9.2.0.6/bin:/binAPT_SAS_Driver in SAS_13
##E TOSA 000001 11:48:53(002) <APT_SAS_Driver in SAS_13> Failure during execution of operator logic.
##I TOSA 000163 11:48:53(003) <APT_SAS_Driver in SAS_13> Input 0 consumed 0 records.
##F TUXX 000002 11:48:55(000) <main_program> Internal Error: (0):subproc/gsubproc.C: 1492: APT_SAS_Driver in SAS_13: execvp failed
Traceback: [6] APT_FatalPath::msgAssertion(0xfedda2d6, 0xffbfc0f4, 0xfedda2d8, 0x5d4, 0xffbfc110, 0xccc70), at 0xff0dad18
[7] APT_GeneralSubprocessOperator::runLocally(0x1067c0, 0x4, 0xfee6146c, 0x1, 0x0, 0xffbfc738), at 0xfea80b24
[8] APT_OperatorRep::run(0x1ce5c8, 0x0, 0x0, 0x0, 0x1067c0, 0xfdc8b714), at 0xfe70f624
[9] APT_SC::Operator::runLocally(0x192470, 0x0, 0xfea42618, 0x0, 0x192490, 0x1924bc), at 0xfea42528
[10] APT_ProcessManager::executePlayer(0x188f44, 0x0, 0x17c00, 0x0, 0xffbfcd30, 0xffbfcd4c), at 0xfea155f0
[11] executeStep(0xfee5e1a4, 0xfea0f054, 0xe1604, 0x4, 0x0, 0xfee5d3e8), at 0xfea12524
[12] APT_PMcontrolServiceTableClass::dispatch(0xb7da0, 0xc10e8, 0xffbfd30c, 0x437c30, 0x1d, 0xe8), at 0xfe9dbd1c
[13] APT_PMMessagePort::dispatch(0xbb7b8, 0xc10f8, 0xc10e8, 0xffbfd308, 0x4, 0xe260), at 0xfe9e3f64
[14] APT_PMMessagePort::poll(0x1, 0x1, 0x0, 0x4, 0x1, 0xfee138b8), at 0xfe9e58ac
[15] APT_PMdispatchLoop(0x1, 0xe07c, 0xfea2ecd0, 0xfee138b8, 0x436b50, 0xe000), at 0xfe9dcd9c

[ArndW]

Your configuration contains a bad path.

...The current PATH is: {text removed}/local/app/oracle/product/9.2.0.6/bin:/binAPT_SAS_Driver in SAS_13

The last part of the string is a malformed expression, ":/binAPT_SAS_Driver" looks like you forgot a "/".

[srinagesh]

Hi !

I put a "/" as suggested by you, by still it doesnt work.

I was talking to some other guys here and they were telling me that this was because SAS was not installed on the datastage server. Is this the case ? Should we have SAS and datastage to be on the same physical box ?