<div>
<div class="content wysiwyg-content">
Experts,<br />
I know there is a way to find all of the tables in a directory in SAS the contain a certain column using Dictionary.columns <br />
<br />
Does anyone know the syntax for this. &nbsp;I remember doing it a while back, but cannot find the code. <br />
<br />
Column = SRC_GRP_NBR <br />
Directory = PROD<br />
<br />
Can someone give me the syntax
</div>
</div>


Experts,
I know there is a way to find all of the tables in a directory in SAS the contain a certain column using Dictionary.columns 

Does anyone know the syntax for this.  I remember doing it a while back, but cannot find the code. 

Column = SRC_GRP_NBR 
Directory = PROD

Can someone give me the syntax

Finding which tables in a Directory contain a column in SAS  using Dictionary.Columns

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.