PharmaSUG2011 – Paper PO08
FAQ: Issues with Efficacy Analysis of Clinical Trial Data
Using SAS
Sandeep Sawant, i3 Statprobe (INGENIX Pharmaceutical Services), India Neha Mohan, i3 Statprobe (INGENIX Pharmaceutical Services), India
ABSTRACT
In pharmaceutical/CRO industry, role of statistical programmers is to support the statistical activities of the clinical trial by means of performing safety and/or efficacy analysis. It is recommended that the statistical programmers should have the knowledge about the statistical methods used especially while working on the efficacy analysis. This however, is not mandatory because detailed specifications are provided by the Biostatisticians. Despite of well written specifications, there is a variety of questions from the programmers regarding the analysis or the outputs produced by SAS® procedures. There are many situations where SAS doesn’t provide the output directly and hence some kind of manipulations is required. This paper is designed to impart a better understanding of efficacy analysis using SAS, as well to communicate the related complexities in the execution and application.
INTRODUCTION
This paper is in a question - answer format and is a collection of questions raised by statistical programmers while performing the efficacy analysis.
Q1) Is there any procedure in SAS using which will compute the Geometric Statistics such as Geometric Mean, Geometric SD and Geometric CV?
Ans: There is no such procedure in SAS which gives the Geometric statistics directly. However, making use of the below formulae, we can compute the required statistics

For instance, if you want to calculate the Geometric Statistics for variable X proceed as follows:
Derive the variable Y as Y=log(X).
Calculate the mean and SD for variable Y using PROC MEANS.
Using the EXP function, calculate the antilog of mean and SD obtained from PROC MEANS. The
resultant values are the Geometric Mean and Geometric SD respectively for the variable X.
Once the geometric SD is obtained, make use of the aforementioned formula to get the Geometric CV.
safety and efficacy results, and submit data to ...data capture to analysis, supporting data ...trial designs and clinical trial simulation, and ...
safety and efficacy results, and submit data to ...data capture to analysis, supporting data ...trial designs and clinical trial simulation, and ...
热门文档