topic How to find location of my sas program in SAS Programming

How to find location of my sas program

SP_SAS — Thu, 12 Jan 2017 18:10:58 GMT

I am running sas 9.4 on grid platform. I want to get the value of the path of my sas program automatically in sas. I use the below code but it gives me the sas workspace location and not my user directory where my program is saved. Any ideas?

%put The current program is %sysfunc(getoption(sysin));

/gridwork/userid/SASGSUB-2017-01-12_13.05.07.758_abc/abc.sas

insted of this I want path of my directory where abc.sas is actually saved.

Thanks,

Santosh

Re: How to find location of my sas program

ballardw — Thu, 12 Jan 2017 18:21:18 GMT

This may work:

%sysget(SAS_EXECFILEPATH)

It is the result of a macro function so could be used as:

title "Program name: %sysget(SAS_EXECFILEPATH)";

%let File = %sysget(SAS_EXECFILEPATH);

It returns the path and name after a file is saved in base SAS. I don't know if it will work in a grid environment.

Re: How to find location of my sas program

SmithCJGVSU — Sun, 09 Feb 2020 17:38:50 GMT

@ballardw I think SAS_EXECFILEPATH is only for Windows and the Enhanced Editor. And, also for interactive mode.

@SP_SAS, Did you ever find a solution to this problem? I'm running into your same problem when running on SAS GRID and I'd be very curious if it's possible to obtain the path dynamically.

Re: How to find location of my sas program

SASKiwi — Sun, 09 Feb 2020 19:23:59 GMT

@SmithCJGVSU - Why do you think a new SAS server session will somehow know where your SAS programs are stored if you haven't identified any of these programs to SAS first? A brand-new SAS session will only know the location of where it was started from and nothing about what programs you want it to run.

I find it useful to set up a macro variable containing the folder location of the required SAS application in a program controlling that application.