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!
Depending on your environment (batch or workspace server), look at option sysin (you can get it in SQL from DICTIONARY.OPTIONS), &SYSPROCESSNAME, &_SASPROGRAMFILE
Depending on your environment (batch or workspace server), look at option sysin (you can get it in SQL from DICTIONARY.OPTIONS), &SYSPROCESSNAME, &_SASPROGRAMFILE
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.