Issue PROC METADATA with VERBOSE. In this example, PROC METADATA issues a GetMetadataObjects method to list all of the objects of type PhysicalTable that are defined in the active repository. The active repository identifier is substituted where $METAREPOSITORY appears in the XML string.

proc metadata 
     in="<GetMetadataObjects>
         <Reposid>$METAREPOSITORY</Reposid>
         <Type>PhysicalTable</Type>
         <Objects/>
         <Ns>SAS</Ns>
         <Flags/>
         <Options/>
         </GetMetadataObjects>" 
     verbose; 
run;