mp_searchcols.sas File Reference

Searches all columns in a library. More...

Go to the source code of this file.

Detailed Description

Scans a set of libraries and creates a dataset containing all source tables containing one or more of a particular set of columns

Usage:

%mp_searchcols(libs=sashelp work, cols=name sex age)

Parameters

[in]	libs=	(SASHELP) Space separated list of libraries to search for columns
[in]	cols=	Space separated list of column names to search for (not case sensitive)
[out]	outds=	(mp_searchcols) The table to create with the results. Will have one line per table match.
[in]	match=	(ANY) The match type. Valid values: ANY - The table contains at least one of the columns WILD - The table contains a column with a name that partially matches

Version

9.2

Author

Allan Bowe

Definition in file mp_searchcols.sas.