DATA Step, Macro, Functions and more

SAS return code is not returned properly to Unix

Reply
Occasional Contributor
Posts: 17

SAS return code is not returned properly to Unix

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

Super User
Posts: 5,429

Re: SAS return code is not returned properly to Unix

Posted in reply to sasbeginner_us
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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 139 views
  • 0 likes
  • 2 in conversation