topic Re: Find the filerefs/directories added to sasautos in SAS Programming

Find the filerefs/directories added to sasautos

DMoovendhan — Thu, 23 Jul 2015 12:10:38 GMT

Hi,

I need to find the filerefs' or the directory location, that are assigned to option sasautos for the sas session thats already executing.

Please let know if there is any option or macro statement to find that.

Regards,

Moovendhan Devaraj

Re: Find the filerefs/directories added to sasautos

Ron_MacroMaven — Fri, 24 Jul 2015 15:38:27 GMT

do you just want to see the list?

*list directory specifications in sasautos;

*list values of environment variables;

*sasroot is your installation folder;

%put %sysget(sasroot);

*environment variable references are preceeded by bang (!);

%put %cmpres(%sysget(sasautos));

*instantiate fileref sasautos;

%include sasautos(af)/nosource2;

filename sasautos list;

*check the option;

*is autocall option true? false::NoMautosource;

%put %sysfunc(getoption(mautosource));

proc options define value option=mautosource;

*what are the filerefs to search see getoption above.

%put %sysfunc(getoption(sasautos)));

proc options define value option=sasautos;

*get list;

proc sql; describe table dictionary.extfiles;

*create table list_filerefs_sasautos as;

select * from dictionary.extfiles

where fileref eq 'SASAUTOS';

quit;

*the pair for compiled and stored macros is;

%put %sysfunc(getoption(mstored));

%put %sysfunc(getoption(sasmstore));

Here are some pages with background information.

http://www.sascommunity.org/wiki/SASautos_Companion_Reusing_Macros

Listing Macros in SASautos - sasCommunity

Re: Find the filerefs/directories added to sasautos

Ksharp — Sat, 25 Jul 2015 13:17:24 GMT

Check dictionary EXTFILES

proc sql;

select *

from dictionary.EXTFILES ;

quit;

Re: Find the filerefs/directories added to sasautos

Tom — Sat, 25 Jul 2015 16:41:25 GMT

The GETOPTION() function can return the value of an option. You can use %SYSFUNC() to call it with macro code.

%put %sysfunc(getoption(sasautos)) ;

If you see that there are FILEREFS used then you can use the PATHNAME() function to get the path(s) that the filerefs refer to.

%put %sysfunc(pathname(sasautos));

Re: Find the filerefs/directories added to sasautos

DMoovendhan — Mon, 14 Sep 2015 10:11:16 GMT

Thank you all, All the replies helped