CDISC Procedure Examples for CDISC SDTM |
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;
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.