Validating CDISC SDTM Data in an Oracle Table

Overview

This example validates CDISC SDTM data that is stored in an Oracle table.

Program

The following SAS program validates CDISC SDTM data that is stored in an Oracle table named AE:

The LIBNAME statement for the SAS/ACCESS Interface to Oracle engine assigns the libref Oralib to the physical location of the Oracle database that contains the Oracle table.
The PROC CDISC statement specifies CDISC SDTM as the model.
The SDTM statement specifies the SDTM version number.
The DOMAINDATA statement specifies the Oracle table to be validated, the two-character domain code, and the domain model type.

libname Oralib oracle user=MyUser pw=mypw 
   path=ora_dbms preserve_tab_names=yes
   connection=sharedread schema=myschema; 1 

proc cdisc model=sdtm; 2  
   sdtm sdtmversion="3.1"; 3                                 
   domaindata data=Oralib.AE domain=AE category=events; 4
run;    

libname Oralib clear;