Invoking SAS script using python - subprocess

Question

I am trying to invoke a sas script using python and subprocess. This is my code:

    proc = Popen(self.cmd, shell=True, stdout=PIPE, stderr=STDOUT)
    proc.wait()
    standard_output, standard_error = proc.communicate()
    if proc.returncode == 0:
        log.info("Successfully executed execute_shell_command")
    elif proc.returncode == 1:
        self.status_message = "return code 1 from" + " ".join(self.cmd) + "error msg: " + str(standard_error)
        self.flag = 1
        raise ValueError(self.status_message)
    elif proc.returncode > 1:
        self.status_message = "Error occurred while executing command on shell :" + " ".join(self.cmd) + ' ' + standard_error
        self.flag = 1
        raise ValueError(self.status_message)

    self.cmd  = [sas_path,'-config',sas_config_path,'-sysin',sas_code_path]

I am not including the autoexec_path for SAS,because I did not find any autoexec file. if I have the autoexec file then,

self.cmd = [sas_path,'-config',sas_config_path,'-autoexec',autoexec_path,'-sysin',sas_code_path]

The problem is the SAS code executes successfully, but proc.returncode is not equal to 0. Therefore, my python code doesn't know that the code ran successfully.
Is there anything that I am doing wrong?

My sas code issued warnings,which is why the return code was 1. — Akash Sharma
– Akash Sharma, Commented Oct 29, 2019 at 5:30

Richard · Accepted Answer · 2019-10-24 20:25:08Z

1

You might have warnings in the log.

From the docs, "SAS® 9.4 Companion for Windows, Fifth Edition"

Return Codes and Completion Status

The return code for the completion of a SAS job is returned in the Windows batch variable, ERRORLEVEL.

…

Values for the ERRORLEVEL Variable

answered Oct 24, 2019 at 20:25

Richard

27.6k4 gold badges28 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Akash Sharma Over a year ago

Thanks Richard. My SAS code log had warnings, which is why I was getting return code 1. This was very helpful.

Richard Over a year ago

Good to hear that and welcome to SO. Be sure to mark answers to your questions and answers to other questions you find helpful. stackoverflow.com/help/someone-answers

Collectives™ on Stack Overflow

Invoking SAS script using python - subprocess

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related