<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have a column DOB which is on TableA &nbsp; one of the tables I am reading into my Oracle query. &nbsp;The query has multiple tables. &nbsp;Can someone tell me how to calculate the age as of Dec 01, 2016.<br />
<br />
I am using a pass-through query in SAS to read the Oracle tables.
</div>
</div>


Experts,

I have a column DOB which is on TableA   one of the tables I am reading into my Oracle query.  The query has multiple tables.  Can someone tell me how to calculate the age as of Dec 01, 2016.

I am using a pass-through query in SAS to read the Oracle tables.

Calculating age in Oracle query

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.