How sas program can find the path to itself

[DmytroYermak]

Hi,

Could you please say how sas program can find the path to itself?

I mean the way on a disk where it is kept.

Thank you!

[Kurt_Bremser · Accepted solution]

Depending on your environment (batch or workspace server), look at option sysin (you can get it in SQL from DICTIONARY.OPTIONS), &SYSPROCESSNAME, &_SASPROGRAMFILE

[DR_Majeti]

Please try below code , it gets the path name.


%macro grabpathname;
%sysget(SAS_EXECFILEPATH)
%mend grabpathname;
%put %grabpathname;

[Kurt_Bremser]

See this log from Enterprise Guide:

27         %macro grabpathname;
28         %sysget(SAS_EXECFILEPATH)
29         %mend grabpathname;
30         %put %grabpathname;
WARNING: The argument to macro function %SYSGET is not defined as a system variable.

and this log from a program run with

sas test.sas

on SAS 9.4M5 on AIX:

1          %macro grabpathname;
2          %sysget(SAS_EXECFILEPATH)
3          %mend grabpathname;
4          %put %grabpathname;
WARNING: The argument to macro function %SYSGET is not defined as a system variable.

So you see this is not reliable.

[DmytroYermak]

Actually I have used the code (some points are project-specific):

%global pathtofile pathdir;
%let pathtofile = %qsubstr(%sysget(SAS_EXECFILEPATH), 1, %length(%sysget(SAS_EXECFILEPATH))-%length(%sysget(SAS_EXECFILEname)));
%let code=\code\;
%let pathdir =%qsubstr(&pathtofile,1,%index(&pathtofile,&code));
%put &pathdir;