How to set SAS program macro variables through a python script

Question

I have multiple SAS program files, each of which has various macro variables which need to be set dynamically through an excel file. I was wondering if I can pass the values from the excel file to the SAS program through a python script (or shell script). I wish to automate the process of setting parameter for each SAS program manually.

Please suggest.

I am trying to automate the execution of all sas programs by setting their parameters through the common excel file.I am reading the excel file and based on the program name I want to set parameters for that particular code file in SAS. If I had to import excel in SAS it does not automate anything for me. @superfluous — codemob
– codemob, Commented Jul 26, 2016 at 20:57
@codemob Well, you could read it into SAS then set the parameters inside of the SAS job? — Joe
– Joe, Commented Jul 26, 2016 at 21:22
Anyway, are you asking a Python question (how do I run [arbitrary program] with [arbitrary parameters] given an excel file), or are you asking a SAS question (how do I run SAS in batch and pass parameters to it)? — Joe
– Joe, Commented Jul 26, 2016 at 21:23
Do you know how to run SAS in batch and pass parameters to it? — Joe
– Joe, Commented Jul 26, 2016 at 21:36

david25272 · Accepted Answer · 2016-08-03 05:13:43Z

1

You can pass a string to SAS using the -sysparm command line option, and this string will be available in SAS as the &sysparm automatic variable.

E.g. (from the command line:)

sas myprogram.sas -sysparm myparam

If you need to parse the string inside SAS, the %scan() macro function will probably be useful.

answered Aug 3, 2016 at 5:13

david25272

9546 silver badges12 bronze badges

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

Comments

codemob · Accepted Answer · 2016-10-13 17:52:11Z

1

So I did figure out how I can solve this:

        subprocess.call(['C:\\Program Files\\SASHome\\SASFoundation\\9.4\\sas.exe', '-config', config_path, '-autoexec', autoexec_path,'-sasinitialfolder',sasinitialfolder,'-sysin', sas_script_path,'-log',ori_log])

I made a subprocess call from python to run it in Bash and I am sending different parameters to this call with respect to the SAS program I am calling. The parameters which I pass from the subprocess call are captured in the SAS program through a %sysget command.Thank you.

answered Oct 13, 2016 at 17:52

codemob

516 bronze badges

Collectives™ on Stack Overflow

How to set SAS program macro variables through a python script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related