<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have a SAS dataset that has one column of distinct codes.<br />
I would like to loop through this table and use the value to select all records from a larger table where the code is equal to the value I just read in. &nbsp;<br />
<br />
How can &nbsp;I do this?
</div>
</div>


Experts,

I have a SAS dataset that has one column of distinct codes.
I would like to loop through this table and use the value to select all records from a larger table where the code is equal to the value I just read in.  

How can  I do this?

Looping through a table in SAS to extract records from another table

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.