Desktop productivity for business analysts and programmers

Using (SAS_EXECFILEPATH) in Enterprise Guide

Reply
N/A
Posts: 0

Using (SAS_EXECFILEPATH) in Enterprise Guide

When running a stored process, our code needs to be able to determine the full path of the code submitted by the stored process.

You can use the following when running SAS in batch mode:

%put %sysget(SAS_EXECFILEPATH);

Does anyone know of a similar function that would work for Stored Processes in Enterprise Guide?

Thanks
SAS Super FREQ
Posts: 8,717

Re: Using (SAS_EXECFILEPATH) in Enterprise Guide

Hi:
On this web site, refer to the explanation of the _PROGRAM reserved macro variable:
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/reserved.html

You may have to change some of your program logic because the path that can be part of the returned value of &_PROGRAM is the metadata repository path ... not the operating system path where the stored process is stored.

cynthia
N/A
Posts: 0

Re: Using (SAS_EXECFILEPATH) in Enterprise Guide

Thanks very much for the suggestion. The _Program macro variable doesn't seem to be getting generated when we run the stored process:

WARNING: Apparent symbolic reference _PROGRAM not resolved.

Any suggestions?
SAS Super FREQ
Posts: 8,717

Re: Using (SAS_EXECFILEPATH) in Enterprise Guide

This is probably a question for Tech Support then. I know that sometimes the reserved macro variables are available on all clients and then sometimes, they're not created or used by a particular client. So you could call that stored process from one client and &_PROGRAM would be available to your program but from another client, it would not be available because you client does not use or surface that macro variable. If &_PROGRAM is not available for your usage situation, it's possible that Tech Support knows of a workaround for you.

To contact Tech Support, go to:
http://support.sas.com/techsup/contact/submit_emits2.html

cynthia
Ask a Question
Discussion stats
  • 3 replies
  • 883 views
  • 0 likes
  • 2 in conversation