Posted By

sarathannapareddy on 04/07/09


sql call XPath proc scan sas symput sashelpvextfl

Versions (?)

Retrieve the path name and filename of executing program ... programmatically

 / Published in: SAS


Oftentimes, I was asked to keep the name and path of the executing program in the FOOTNOTE of the generated table or listings.

I have always created a macro variable using the %let statement and, then I called the Macro variable in the footnote statement to get the name of the program. Eventhough it is simple.. it may not be suitable when we write application which need to self document...

Here is another technique which can be used to retrieve the pathname and filename (last executed) .....

To get the last opened filename:

proc sql noprint; select scan(xpath,-1,'\') into :progname from sashelp.vextfl where upcase(xpath) like '%.SAS'; quit;

%put &progname; read more.. at ...


Report this snippet  

You need to login to post a comment.