topic Re: Ever seen SASUSER defined as aggregate library? in SAS Programming

Ever seen SASUSER defined as aggregate library?

Tom — Sat, 16 Feb 2019 18:34:23 GMT

You can define a libref or a fileref to point to multiple physical directories.

filename myfile ('path1' 'path2' 'path3');
libname mylib ('path1' 'path2' 'path3');

I was reviewing a program where the code went to a lot of work to handle the possibility that the SASUSER libref was pointing to multiple physical directories.

My question is:

Has anyone ever seen a situation where SAS will actually define SASUSER to point to more than one physical directory?

Re: Ever seen SASUSER defined as aggregate library?

Reeza — Sat, 16 Feb 2019 19:47:39 GMT

I can't check right now, but I believe that's true by default in the config file. SASHELP points to several directories as well.

Re: Ever seen SASUSER defined as aggregate library?

Tom — Sat, 16 Feb 2019 20:49:55 GMT

But I have never seen it for SASUSER and cannot even think of a case where you would want to point SASUSER to multiple directories.

SASHELP on Windows definitely points to multiple directories.

802   %put %sysfunc(pathname(sashelp));
( 'C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG' 'C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\aacomp\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\af\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\assist\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\cas\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\cmp\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\connect\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\eis\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\graph\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\mlearning\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\qc\sashelp' 'C:\Program Files\SASHome\SASFoundation\9.4\spdsclient\sashelp' 'C:\Program
Files\SASHome\SASFoundation\9.4\stat\sashelp' )

On Unix usually not as many.

1    %put %sysfunc(pathname(sashelp));
( '/Volumes/app/sas/prod/sas9.4/SASFoundation/9.4/nls/en/sascfg'
'/Volumes/app/sas/prod/sas9.4/SASFoundation/9.4/nls/en/sascfg'
'/Volumes/app/sas/prod/sas9.4/SASFoundation/9.4/sashelp' )

Re: Ever seen SASUSER defined as aggregate library?

SASKiwi — Sat, 16 Feb 2019 22:21:04 GMT

What would be the use of an aggregate SASUSER library? The idea of the SASUSER is to store user-specific data and configurations. For example the SAS Windowing Environment stores its PROFILE catalog here. With an aggregate library only the first directory in the sequence would ever get written to when using SASUSER.

Re: Ever seen SASUSER defined as aggregate library?

Kurt_Bremser — Sun, 17 Feb 2019 06:51:28 GMT

Imagine a directory with a formats.sas7bcat in it. Appending that to the user's own sasuser.v94 by using a concatenated SASUSER might be used to distribute formats from a central location, but there are much better ways to achieve this.

Re: Ever seen SASUSER defined as aggregate library?

Tom — Mon, 18 Feb 2019 20:02:25 GMT

Thanks. I suspect that the code was copied from a situation where multiple directories were possible for the libref they wanted to search.

Anyway here is what I came up with as a compromise just in case anyone actually did try to point SASUSER to multiple directories.

*----------------------------------------------------------------------------;
* Check for xxxx.txt file in SASUSER directory. ;
*----------------------------------------------------------------------------;
%let _filename=;
data _null_;
  set sashelp.vlibnam;
  by level;
  where libname='SASUSER';
  if first.level;
  if fileexist(catx('/',path,'xxxx.txt')) then do;
    call symputx('_filename',catx('/',path,'xxxx.txt'));
    stop;
  end;
run;