DATA Step, Macro, Functions and more

Passing Filename as parameters to SAS program

Reply
Contributor
Posts: 69

Passing Filename as parameters to SAS program

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.

Super User
Super User
Posts: 7,942

Re: Passing Filename as parameters to SAS program

Posted in reply to Siddhartha

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

 

Regular Contributor
Posts: 161

Re: Passing Filename as parameters to SAS program

[ Edited ]
Posted in reply to Siddhartha

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...!!!

Kannan Deivasigamani
Ask a Question
Discussion stats
  • 2 replies
  • 352 views
  • 0 likes
  • 3 in conversation