Abstract #301088


The views expressed here are those of the individual authors
and not necessarily those of the ASA or its board, officers, or staff.


Back to main JSM 2002 Program page



JSM 2002 Abstract #301088
Activity Number: 92
Type: Topic Contributed
Date/Time: Monday, August 12, 2002 : 10:30 AM to 12:20 PM
Sponsor: Biopharmaceutical Section*
Abstract - #301088
Title: A Highly Automated Crossover Study Analysis System for Non-statisticians
Author(s): Donghui Zhang*+ and Ting-Chuan Wang
Affiliation(s): Merck & Company, Inc. and Merck & Company, Inc.
Address: PO BOX 2000, RY70-38, Rahway, New Jersey, 07065, USA
Keywords: Crossover ; Automation ; VBA for Excel ; SAS
Abstract:

Crossover designs are commonly used in preclinical and clinical PK/PD studies, bioavailability, and bioequivalence studies. The preferred designs for higher order crossover studies should be balanced for the carryover effects, and such preferred designs usually have standard layouts depending on the number of periods and treatments. An automated system is developed for the statistical analysis of balanced 3X3 and 4X4 crossover designs. Visual basic for application (VBA), for Excel, is utilized as front end for graphical user interface (GUI), data I/O and manipulation. SAS, invoked inside VBA, using OLE, serves as an engine for statistical analysis and graphics. SAS/ODS generates results in text format and VBA, then finally reformats and delivers the results to the end users in Excel. This system is highly automated, which requires minimum user intervention to input subject allocation information in GUI. A non-statistician (e.g., a scientist or clinical investigator) can use it at ease with no knowledge on modeling SAS and VBA.


  • The address information is for the authors that have a + after their name.
  • Authors who are presenting talks have a * after their name.

Back to the full JSM 2002 program

JSM 2002

For information, contact meetings@amstat.org or phone (703) 684-1221.

If you have questions about the Continuing Education program, please contact the Education Department.

Revised March 2002