Copyr i g ht © 2014, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

SUPER DEMO: THE INTEGRATION OF SAS

DRUG DEVELOPMENT AND SAS CLINICAL

DATA INTEGRATION

JULIE MADDOX

SAS INSTITUTE

PHARMASUG 2014

2

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

What Is SAS Drug Development?

Key Features:

Secure centralized content repository

Integrated SAS development and

execution environment

Auditing and traceability

Work and task management

Job management and scheduling

Collaborative work environment

3

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

What Is SAS ClinicalData Integration?

Provides support for

CDISC standards,

SEND, SDTM,

ADaM, Define

Centralized metadata

management

Visual transformation

tools

4

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Advantages of Hosting SAS Drug Development & SAS Clinical Data Integration

Shared Environment: Metadata Server and SAS

Workspace Server

Shared workspace for programs and data

Dynamic Library/File assignments using macro variable

Code developed in CDI executes without changes

inside SDD

4

5

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Hosted SAS Drug Development & SAS Clinical Data Integration

5

Client

Clinical Data

Integration

Via Terminal Server

Application Servers

SAS Metadata

Server

SAS Workspace

Servers

Shared SAS Servers

SAS Drug

Development

Via Browser

6

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Scenario - Creating the Define.xml File

SAS Clinical Data Integration,

provides a CDISC-Define

transformation to build the

define.xml file from the study

domain metadata.

7

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

CDI Job to create Define File

7

Provide list of

Domain tables

and location

to include in

the define file

Provide name

and location

of define file

CDI Document

Object

SAS Library

Object

8

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Advantages of Hosting SAS Drug Development & SAS Clinical Data Integration

Shared Environment: Metadata Server & SAS

Workspace Server

Shared workspace, for programs, data

– Macro variable identifies the location of the

root-level folder for the SDD Workspace

– Allows for the same program to run in CDI, in the

SDD Workspace as well as the SDD Repository

without any modifications.

8

9

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

_sasws_ Macro Variable

This macro variables can be referenced in SAS programs.

LIBNAME statements

FILENAME statements

Other SAS statements

9

libname sdtm "&_sasws_/QAGPharma/PainXD-Study101/Files/Data/sdtm";

filename define "&_sasws_/QAGPharma/PainXD-Study101/Files/define.xml";

%include "&_sasws_/QAGPharma/PainXD-Study101/Files/Macros/setup.sas";

%let StudyPath=&_sasws_/QAGPharma/PainXD-Study101;

10

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Define.xml File Properties

10

11

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

SAS Library Properties for SDTM domains

11

12

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Develop Code in CDI, Save directly into SDD

12

13

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Saved CDI Code appears in SDD workspace

13

14

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Execute CDI Code in SDD – no code changes required

14

15

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Define file is created in the Specified folder

15

16

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Check in Program into Repository

16

Mark program for addition and check it in to repository

17

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

Advantages of a Hosting SAS Drug Development & SAS Clinical Data Integration

Shared Environment: Metadata Server and SAS

Workspace Server

Shared workspace for programs and data

Dynamic Library/File assignments using macro variable

Code developed in CDI executes without changes

inside SDD

17

Copyr i g ht © 2014, SAS Ins t i tu t e Inc . A l l r ights reser ve d .sas.com

QUESTIONS ???

Copyr i g ht © 2014, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

SAS LIFE SCIENCE ANALYTICS

FRAMEWORK

JULIE MADDOX

SAS INSTITUTE

PHARMASUG 2014