25.9.08
24.9.08
11.10.07
Wilcoxon Signed Rank test
proc univariate data= eff_data;
var diff;
run;
ods output close;
The output will contain p-value corresponding to Student’s t, Sign and Signed Rank tests. The p-value corresponding to the signed rank test will be considered. Further, For a 1-sided p-value, we would divide the 2-sided p-value by 2.
25.7.07
For the analysis of any clinical trial on asthma inhalers, your efficacy parameters are most probably going to be related to the spirometry measures and will almost always include the following FEV1 - Forced expiratory volume in 1 second The FEV1 is the volume exhaled during the first second of a forced expiratory maneuver started from the level of total lung capacity.
PEF - Peak expiratory flow Expiratory peak flow (PEF) is the maximum flow generated during expiration performed with maximal force and started after a full inspiration .
FVC - Forced expiratory vital capacity The volume change of the lung between a full inspiration to total lung capacity and a maximal expiration to residual volume. Here are more details on Spirometry. Also check out GINA for more Asthma information

So how do we do it ? We look at the Clinical Protocol and create a Blind Review Criteria document which will list out all the conditions that needs to be checked against the data to make sure that there is no violations. For eg. if Visit 1 were to happen with in 15-20 days of the screening visit, then we compare the dates of screening and visit1 and if the difference falls below 15 and above 20, then boom we have a violation. Then we write a SAS program to check all those conditions and run it to create a protocol violation document.
Easily said. But to do it and to make sure that all the violations are caught is one hell of a task Johnny.
4.7.07
In the field of pharmacokinetics, the area under the curve (AUC) is the area under the curve in a plot of concentration of drug in plasma against time.In real-world terms the AUC (from zero to infinity) represents the total amount of drug absorbed by the body, irrespective of the rate of absorption. This is useful when trying to determine whether two formulations of the same dose (for example a capsule and a tablet) release the same dose of drug to the body.
AUC becomes useful for knowing the average concentration over a time interval, AUC/t. Also, AUC is referenced when talking about elimination.
The amount eliminated by the body = clearance (volume/time) * AUC (mass*time/volume).
Another application that we recently found is when we try to establish the equivalence of two asthma formulations and their superiority over placebo. Here are some links if you
a. want to learn how we can use integration to find the AUC
b. A small SAS macro to calculate AUC using trapezoidal rule
c. Use proc expand to find out the AUC
27.6.07
Here is the small and handy piece of sas code to extract data off of a mySQL database to SAS
/*Importing datasets from SQL to SAS*/
libname sqllibrary ODBC datasrc='DBDRIVER' user=root password=root schema="testdb";
proc copy out=workdb in=testdb;
exclude validation schema_info;
run;
You will need to install the ODBC driver for MySQL before you venture into running this code
Let μS = mean of standard treatment, μT = mean of new treatment, and δ = the minimum clinically important difference.
2. Test for Non-inferiority: To demonstrate that the new drug is as less effective as the standard treatment (ie the difference between the new treatment and the standard is less than the smallest clinically meaningful difference)
3. Test for Superiority: To demonstrate that the new treatment is more superior that standard treatment (ie the difference between the new treatment and the standard is greater than the smallest clinically meaningful difference).
4. Test for equivalence: To demonstrate the difference between the new treatment and standard treatment has no clinical importance

the test for superiority is often referred to as the test for clinical superiority
If δ = 0, it is called the test of statistical superiority
Equivalence is taken to be the alternative hypothesis, and the null hypothesis is nonequivalence