Interactive Visualization of Clinical Laboratory Parameters with SAS - - PowerPoint PPT Presentation

▶
interactive visualization of clinical laboratory
SMART_READER_LITE
LIVE PREVIEW

Interactive Visualization of Clinical Laboratory Parameters with SAS - - PowerPoint PPT Presentation

Oct 16, 2023 258 likes •489 views

Interactive Visualization of Clinical Laboratory Parameters with SAS Stored Processes and jQuery AJAX PhUSE Conference 2017, Edinburgh October 9, 2017 / Volker Harm Motivation Fundamental steps The dashboard structure The data

slide-1
SLIDE 1

October 9, 2017 / Volker Harm

PhUSE Conference 2017, Edinburgh

Interactive Visualization of Clinical Laboratory Parameters with SAS Stored Processes and jQuery AJAX

slide-2
SLIDE 2

Agenda

Interactive Visualization of Clinical LaboratoryParameters Page 2

  • Motivation
  • Fundamental steps
  • The dashboard structure
  • The data
  • The selections
  • The graph
  • Some refinements
  • Autocomplete selection with jQuery AJAX
  • One step beyond
slide-3
SLIDE 3

Innovation initiatives at Bayer

  • Visualizing data is one of the hot topics

What could be the part of our Research and Clinical Sciences Statistics department?

  • Idea of my boss:
  • Could we use the SAS Stored Processes to present Clinical Laboratory Data

in a “dashboard” interactively on the intranet?

  • As a prerequisite he had a tool collect the data in one standardized SAS data

set.

  • Typical Phase I studies are small and results are examined carefully for each

patient and parameter.

  • A presentation on screen should much more convenient than wading through

a pile of tables and figures on paper.

Motivation

Interactive Visualization of Clinical LaboratoryParameters Page 3

slide-4
SLIDE 4

And here is the requirements document:

Interactive Visualization of Clinical LaboratoryParameters Page 4

slide-5
SLIDE 5

And this is, what I found with Google

Interactive Visualization of Clinical LaboratoryParameters Page 5

slide-6
SLIDE 6

The main SAS Stored Process

Let’s start: SAS Sample 43723

Interactive Visualization of Clinical LaboratoryParameters Page 6

slide-7
SLIDE 7

The dashboard structure

The first request

Interactive Visualization of Clinical LaboratoryParameters Page 7

slide-8
SLIDE 8

The selection form

The second request

Interactive Visualization of Clinical LaboratoryParameters Page 8

slide-9
SLIDE 9

Individual measurements (LBSTRESN, LBSTRESU)

  • For each treatment (TRTP, TRTPN)
  • For each parameter (LBTEST, LBTESTCD)
  • For each subject (USUBJID)
  • For each visit (VISIT, VISITNUM)

Summary data over subjects

  • For each treatment
  • For each parameter
  • For each visit

Clinical Laboratory Parameter Data

Interactive Visualization of Clinical LaboratoryParameters Page 9

For sake of brevity we will concentrate on individual measurements.

slide-10
SLIDE 10

Structure of Laboratory Data Set

Interactive Visualization of Clinical LaboratoryParameters Page 10

  • cp. Shostack, Jack.2014. SAS Programming in the Pharmaceutical Industry, Second Edition. Cary, NC: SAS Institute Inc
slide-11
SLIDE 11

Creation of selection tags with SAS

Interactive Visualization of Clinical LaboratoryParameters Page 11

slide-12
SLIDE 12

The report for the selected parameters

The third request

Interactive Visualization of Clinical LaboratoryParameters Page 12

slide-13
SLIDE 13

Visualization dashboard

Interactive Visualization of Clinical LaboratoryParameters Page 13

slide-14
SLIDE 14

Autocomplete selection with jQuery AJAX

Interactive Visualization of Clinical LaboratoryParameters Page 14

slide-15
SLIDE 15

The jQuery script

Interactive Visualization of Clinical LaboratoryParameters Page 15

Code for the SAS Stored Process lookupParameters is not presented.

slide-16
SLIDE 16

The code for the layout

Interactive Visualization of Clinical LaboratoryParameters Page 16

slide-17
SLIDE 17

One step beyond

Interactive Visualization of Clinical LaboratoryParameters Page 17

slide-18
SLIDE 18

Use plotly.js present the graph

Interactive Visualization of Clinical LaboratoryParameters Page 18

slide-19
SLIDE 19

Did I meet the requirements

Interactive Visualization of Clinical LaboratoryParameters Page 19

slide-20
SLIDE 20

The structure of SAS Sample 43723 provides a means to produce basic dashboards.

  • It is not easy to understand, how it works.
  • The internet says it is outdated, so there is no documentation.
  • But: It works! And there many, many ways to enhance it.

jQuery AJAX is mainly addressed at web page builder.

  • You have to become one, if you want to use it effectively.

Wait for the paper!

  • The paper contains code for fully worked out example and a long list of

recommended reading. If you are using SAS Stored Processes: Try out plotly.js! If you are interested in all this stuff: Go to presentation AD02!

Take home

Interactive Visualization of Clinical LaboratoryParameters Page 20

slide-21
SLIDE 21

Thank you!