topic Re: Finding the execution path, advanced question? in SAS Procedures

Finding the execution path, advanced question?

RFLinnenbank — Tue, 08 Sep 2009 07:38:28 GMT

I managed to find how deal with finding the application's execution path when batch submitting and for running it straight from SAS (9.1.3 by the way), but there appears to be a third type of situation:

When right-clicking the application-file you also get an option "Submit with SAS 9.1". When execution through this option neither SAS_EXECFILEPATH nor SYSIN will be used to store the execution path.
(SYSPROCESSNAME indicates "DMS process" like with running it from SAS)

Is it possible to obtain the execution path even under these circumstances? -changed title to clear things up-

Message was edited by: RFLinnenbank

Re: Finding the execution path, advanced question?

data_null__ — Tue, 08 Sep 2009 11:57:17 GMT

My very small sample and limited testing shows that a FILEREF FLn where n is a number is used with "Submit with SAS 9.1"

Use DICTIONARY.EXTFILES to get info.

Re: Finding the execution path, advanced question?

RFLinnenbank — Tue, 08 Sep 2009 12:15:56 GMT

Thanks for the rapid response! I'll work this in as soon as I get the chance!

Re: Finding the execution path, advanced question?

sarathannapareddy — Tue, 08 Sep 2009 12:34:23 GMT

* Using SASHELP Views ( vextfl) to get the filename or pathname;

*To get the filename only;

data _null_;
set sashelp.vextfl(where=(upcase(xpath) like '%.SAS'));
call symput('program', scan(xpath,-1,'\'));
run;

*To get pathname;

data _null_;
set sashelp.vextfl
(where=(upcase(xpath) like '%.SAS'));
call symput('progrm', xpath);
run;

Read more at: http://studysas.blogspot.com/2009/04/how-to-determine-executing-program-name.html

Sarath