topic Re: Find Path of SAS program in SAS Programming

Find Path of SAS program

Ronein — Thu, 05 Jan 2023 07:22:13 GMT

Hello,

Let's say that I have 2 SAS programs: "Program1", "Program2".

Let's say that within the code of "Program1" I want to write a command (statement) to run "Program2"

It means that When "program1" is running then "Program2" will run two and I don't need to open "program2" in order to run it.

For that task I need to write include statement as following:

%include "/path/program.sas";

The problem that I don't know the path of "Program2"

I wrote

%let rc = %sysfunc(filename(fr,.));
%let curdir = %sysfunc(pathname(&fr));

and got

/usr/local/SAS/Config/Lev1/LabRet

Then I tried

%include "/usr/local/SAS/Config/Lev1/LabRet/program1.SAS";

and got error

WARNING: Physical file does not exist, /usr/local/SAS/Config/Lev1/LabRet/program1.SAS.
ERROR: Cannot open %INCLUDE file /usr/local/SAS/Config/Lev1/LabRet/program1.SAS.

My question:

How can I find the correct path to my sas program?

Please

Re: Find Path of SAS program

andreas_lds — Thu, 05 Jan 2023 07:32:26 GMT

Depends on the application used to execute code. Run %put _all_; to get all macro-variable, in SAS Studio and Display Manager there should be a variable named "_SASPROGRAMFILE" pointing to the path of the current program. Using string function to extract the path shouldn't be difficult. In EG 8.3 I see that variable, too.

Re: Find Path of SAS program

Patrick — Thu, 05 Jan 2023 12:12:38 GMT

Why don't you know where your programs are stored? Are you eventually trying to include code that only exists in your client side EG/Studio project but not on the file system as a file?

Re: Find Path of SAS program

Quentin — Thu, 05 Jan 2023 13:32:59 GMT

I'm confused. Looks like your code is running on linux SAS. What client are you using to submit code? (EG, studio, etc)?

Where is program1.sas stored?

Where is program2.sas stored?

Are you saying you know that program1.sas and program2.sas are stored in the same directory, but you don't want to hard-code the path?

If you have a standard directory structure that stores your code for each project, one option is to make a macro var with the path to the code directory, e.g.:

%let CodeDir= /home/mystuff/ProjectFoo/Code ;

So you hard code the directory one place, but then can use the macro variable in filename statement, include statement, etc.

You can often avoid hard-coding completely, but the solution depends on your client, and the setup of your file structures.

Re: Find Path of SAS program

Reeza — Thu, 05 Jan 2023 16:22:20 GMT

@Ronein wrote:
 open %INCLUDE file /usr/local/SAS/Config/Lev1/LabRet/program1.SAS.
My question:

How can I find the correct path to my sas program?

Please

I'm guessing your path is relative and in the same folder as program 1? Or is it a level above, below? You have to know where it should be relative to the running program or know the absolute path to reference it.