SAS return code is not returned properly to Unix

sasbeginner_us — Thu, 12 Nov 2015 21:09:43 GMT

Hi,

I am calling a sas program from ksh script (inside a while do loop) and have the below code to capture the sas return code but it is not working. The sas code failed in a proc sql statement but returned 0 to ksh. Please let me know what is wrong here..

ksh:

------

sas ${sas_path}/test.sas \
           -sysparm "$name $date " \
           -log    $log_path/test.log.${name}.${rundatetime} \
        -print $log_path/test.lst.${name}.${rundatetime}
         wait
        rc_sas=$?

            if [[ $rc_sas -ge 3 ]]
        then
          echo $rc_sas
         print "see file"

sas log:

----------

ERROR: Teradata prepare: An owner referenced by user does not have SELECT WITH GRANT OPTION access

ksh log:

----------

+ wait
+ rc_sas=0
+ [[ 0 -ge 3 ]]

Re: SAS return code is not returned properly to Unix

LinusH — Thu, 12 Nov 2015 21:29:06 GMT

It seems that your Teradata error does not affect the SAS error status. Seeing the calling SAS step would help. If you are using SQL check the SQLXRC macro variable.

topic Re: SAS return code is not returned properly to Unix in SAS Programming

SAS return code is not returned properly to Unix

Re: SAS return code is not returned properly to Unix