mp_dirlist.sas File Reference

Returns all files and subdirectories within a specified parent. More...

Go to the source code of this file.

Detailed Description

When used with getattrs=NO, is not OS specific (uses dopen / dread).

If getattrs=YES then the doptname / foptname functions are used to scan all properties - any characters that are not valid in a SAS name (v7) are simply stripped, and the table is transposed so theat each property is a column and there is one file per row. An attempt is made to get all properties whether a file or folder, but some files/folders cannot be accessed, and so not all properties can / will be populated.

Credit for the rename approach: https://communities.sas.com/t5/SAS-Programming/SAS-Function-to-convert-string-to-Legal-SAS-Name/m-p/27375/highlight/true#M5003

usage:

%mp_dirlist(path=/some/location,outds=myTable)

%mp_dirlist(outds=cwdfileprops, getattrs=YES)

%mp_dirlist(fref=MYFREF)

Warning

In a Unix environment, the existence of a named pipe will cause this macro to hang. Therefore this tool should be used with caution in a SAS 9 web application, as it can use up all available multibridge sessions if requests are resubmitted. If anyone finds a way to positively identify a named pipe using SAS (without X CMD) do please raise an issue!

Parameters

path=	for which to return contents
fref=	Provide a DISK engine fileref as an alternative to PATH
outds=	the output dataset to create
getattrs=	YES/NO (default=NO). Uses doptname and foptname to return all attributes for each file / folder.

Returns

outds contains the following variables:

• directory (containing folder)
• file_or_folder (file / folder)
• filepath (path/to/file.name)
• filename (just the file name)
• ext (.extension)
• msg (system message if any issues)
• OS SPECIFIC variables, if getattrs= is used.

Version

9.2

Author

Allan Bowe

Definition in file mp_dirlist.sas.