After you know how a table is defined, you can use its column names in a subsetting WHERE ... from the DICTIONARY.CATALOGS table: proc sql ; title 'Subset of the DICTIONARY.CATALOGS Table'; title2 ...