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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.