Beate Danielsen, Health Information Solutions
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Beate Danielsen, Health Information Solutions Soora Wi, Kaiser Permanente Eileen Walsh, Kaiser Permanente. Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies. Is this Presentation for You?.

Download Presentation

Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Web based integration of data collection and reporting based on sas foundation technologies

Beate Danielsen, Health Information Solutions

Soora Wi, Kaiser Permanente

Eileen Walsh, Kaiser Permanente

Web-Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies

Is this presentation for you

Is this Presentation for You?

  • Need for customized data collection possibly at different sites connected by an intranet or the internet

  • SAS foundation technologies available including staff resources familiar with those technologies

  • Need for customized data reports delivered via an intranet or the internet

  • Need for flexibility in terms of data collected and reports generated

Structure of presentation

Structure of Presentation

  • Brief introduction to a custom data collection at Kaiser Permanente – Division of Research

  • Status and challenges 2 years ago

  • Features of re-designed application

  • Cost / Benefit considerations

  • Outlook and future goals

Introduction to nmds

Introduction to NMDS

  • Neonatal Minimum Data Set (NMDS)

  • On-line data collection from Kaiser Permanente’s 6 Level III Neonatal Intensive Care Units

    •  18,000 infants screened annually for eligibility

    •  3,000 eligible infants annually

    • Up to  800 variables collected per infant stay

  • Data used for monitoring health outcomes, participation in QI initiatives, performing research, and more

  • On-line reporting

Status and challenges 2 years ago

Status and Challenges 2 Years Ago

  • Web-based application relying on HTML, JavaScript, JSP/Java/JDBC, Tomcat, Oracle, and SAS

  • Necessity of exporting Oracle tables into SAS

  • Limited on-line help

  • Limited real-time error checking

  • Lack of on-line reporting

  • Considerable delay between NICU encounter and its abstraction into the database and additional delays to NICU reports

  • Need of outside programmer for system changes such as addition of new variables or any type of application maintenance

  • No support of other constituents

Re designed application

Re-Designed Application

Web server passes variables in specific format generated via CGI script

Browser sends http request

(a completed HTML form)

Kaiser DOR


Kaiser DOR Intranet


Client PC

Web server returns HTML and other

generated content such as figures, XML documents, etc. that it received from application server

Runs SAS program and sends

result as HTML / XML

Application Server

SAS Base



Unix System

Web Server


Unix System


Nmds v application features

NMDS-V Application Features

  • Web-based

  • SAS data sets

  • DBs fully managed through application

  • Data integrity checks built into application using JavaScript and comprehensive SAS-based error check

Nmds v application features1

NMDS-V Application Features


  • User-friendly environment with relevant help screens

  • Multiple levels of access (e.g., review-only user, abstractor, supervisor, DB reports only)

  • Database activity reports and other custom reports helpful in the abstraction process

  • Integration of an expanded data collection on a subset of cases

Nmds v application features2

NMDS-V Application Features


  • Integrated reporting

  • Ability to populate some of the SAS DBs from other sources

  • Support DB generation to meet needs of multiple constituents: national and statewide patient outcome registries, payer-sponsored quality benchmarking programs, and regional/local QI initiatives by KP clinical staff

Cost benefit considerations

Cost / Benefit Considerations

Legacy System

Re-designed SAS-based System

Simpler set up requiring SAS only

Real-time error checks

Flexible: Data collection, user management, reporting, support of QI projects built-in

Application built and in production within 6 months

Staff time needed for data entry reduced from 6.0 to 4.0 FTEs

Increased independence of KP staff

  • More complicated set up requiring the maintenance of multiple software products

  • Limited real-time error checking

  • Relatively inflexible, data collection only with limited flexibility to add/remove data elements

Outlook and future goals

Outlook and Future Goals

  • Integration of legacy data into re-designed application

  • Population of database variables through other KP databases particularly the EMR further reducing abstracting time

  • Continuous improvement of application interface based on user feedback

  • Expanded reporting

Response to concerns questions

Response to Concerns / Questions

  • SAS/IntrNet only solutions are difficult to maintain

    • Entirely dependent on the application designer

    • NMDS implementation makes it easy to find relevant modules (“gatekeeper” macro)

  • is a better solution

    • Only available on Windows-based web servers, therefore not platform independent

    • Need for ASP programmer



SAS Foundation Technologies combined with basic web techniques provide a powerful tool to institutions vested in SAS to generate completely customized and flexible solutions for data collection and informative reporting.

Contact information

Contact Information

Beate Danielsen, Health Information [email protected]

Soora Wi, Kaiser [email protected]

Eileen Walsh, Kaiser [email protected]

  • Login