topic Re: How sas program can find the path to itself in SAS Programming

How sas program can find the path to itself

DmytroYermak — Fri, 30 Mar 2018 08:06:23 GMT

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!

Re: How sas program can find the path to itself

Kurt_Bremser — Fri, 30 Mar 2018 08:46:11 GMT

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

Re: How sas program can find the path to itself

DR_Majeti — Fri, 30 Mar 2018 08:51:19 GMT

Please try below code , it gets the path name.

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

Re: How sas program can find the path to itself

Kurt_Bremser — Fri, 30 Mar 2018 08:57:14 GMT

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.

Re: How sas program can find the path to itself

DmytroYermak — Fri, 30 Mar 2018 12:07:38 GMT

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;