Hi @sabid
SAS is not a database. A SAS data set is just a disk file with the extension sas7bdat, that exists in a given directory, but it is invisible to SAS until the directory is assigned as a SAS Library to the current SAS session with a libname statement.
Then SAS can see the given dictionary as a SAS Library and the files in the directory as SAS tables and supply dictionary information in the SASHELP library. But this works only if the given directory is assigned as a Libname in the current session.
To find all physical SAS data sets in the server, it is necessary to identify all files with extension sas7bdat by a recursive directory listing of the whole server directory structure, or the parts of it that might contain SAS data sets. That cannot be done in SAS, but requires a system command, the DIR command in Windows or the LS command in Linux, and the command must be executed by a user who is authorized to list content in all relevant directories (or read files, if you proceed to step 2 below).
The DIR or LS command can be called from SAS EG or DI, if the command is called in a filename PIPE stetement, and the command output can be read with a SAS data step for further processing. This way it is possible to obtain a list of all directories containing SAS data sets + the data sets in these directories.
In a step 2, a SAS macro can be built to loop over a distinct list of directories and assign them as libnames, and then the full directory information can be obtained from SASHELP tables.
