topic Re: Passing Filename as parameters to SAS program in SAS Programming

Passing Filename as parameters to SAS program

Siddhartha — Tue, 27 Oct 2015 09:38:01 GMT

We need to call the sas program from unix shell with the filenames to be passed as parameters. Please help us how can we pass a parameter to sas program from command line as argument and how it has to be handleled inside the SAS program.

The scenario is to call a same sas program in the weekly and monthly job with the different set of files.

Re: Passing Filename as parameters to SAS program

RW9 — Tue, 27 Oct 2015 10:12:51 GMT

Well, me personally, I would just have a folder, and put the relevant files in. Then using specific software have the program run as and when on any files in that directory. Far easier. However if you have to then check out this article:

http://blogs.sas.com/content/iml/2015/03/16/pass-params-sysget.html

Re: Passing Filename as parameters to SAS program

kannand — Tue, 27 Oct 2015 12:02:13 GMT

Here is an example that might help you....

Unix Shell Code called "sasparm.sh"

sas sasparm.sas -sysparm "$1"

Your SAS program code called "sasparm.sas"

options mlogic mprint symbolgen;
%let var1="&sysparm";
data in;
  input_value=&var1;
run;

When you invoke the script, you may invoke like this in the command line...

sasparm.sh filename

Good Luck...!!!