BookmarkSubscribeRSS Feed
SP_SAS
Obsidian | Level 7

I am running sas 9.4 on grid platform. I want to get the value of the path of my sas program automatically in sas. I use the below code but it gives me the sas workspace location and not my user directory where my program is saved. Any ideas?

%put The current program is %sysfunc(getoption(sysin));

 

/gridwork/userid/SASGSUB-2017-01-12_13.05.07.758_abc/abc.sas

 

insted of this I want path of my directory where abc.sas is actually saved.

 

Thanks,

Santosh

 

3 REPLIES 3
ballardw
Super User

This may work:

%sysget(SAS_EXECFILEPATH)

It is the result of a macro function so could be used as:

title "Program name: %sysget(SAS_EXECFILEPATH)";

or

%let File = %sysget(SAS_EXECFILEPATH);

 

It returns the path and name after a file is saved in base SAS. I don't know if it will work in a grid environment.

SmithCJGVSU
Obsidian | Level 7

@ballardw I think SAS_EXECFILEPATH is only for Windows and the Enhanced Editor.  And, also for interactive mode.

 

@SP_SAS, Did you ever find a solution to this problem?  I'm running into your same problem when running on SAS GRID and I'd be very curious if it's possible to obtain the path dynamically.

 

 

SASKiwi
PROC Star

@SmithCJGVSU - Why do you think a new SAS server session will somehow know where your SAS programs are stored if you haven't identified any of these programs to SAS first? A brand-new SAS session will only know the location of where it was started from and nothing about what programs you want it to run.

 

I find it useful to set up a macro variable containing the folder location of the required SAS application in a program controlling that application.

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 3857 views
  • 1 like
  • 4 in conversation