SAS return code is not returned properly to Unix

[sasbeginner_us]

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 ]]

[LinusH]

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.