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;