Macros for SAS Application Developers 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


%mp_searchcols(libs=sashelp work, cols=name sex age)
libs=(SASHELP)Space separated list of libraries to search for columns
cols=Space separated list of column names to search for (not case sensitive)
outds=(mp_searchcols)the table to create with the results. Will have one line per table match.
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
Allan Bowe

Definition in file