SP09
Two Step Approach to Automatically Generate ESTIMATE Statements for Pair-wise Treatment Comparisons
Eric Qi, Merck & Co
Guanghan (Frank) Liu, Merck & Co

To do pair-wise treatment comparisons in a clinical study with repeated measures, we often use ESTIMATE statements in the PROC MIXED procedure. However, writing ESTIMATE statements sometimes may be challenging, that is especially true when some weights a re considered for stratification factors in the analysis model. This paper explains how to use a two step approach to automatically generate ESTIMATE statements using SAS macro program. The first step is to get the coefficients needed for ESTIMATE statem ents through LSMEANS statement and build the ESTIMATE statements for the user. The second step is to run the PROC MIXED code again with the generated ESTIMATE statements. This paper shows a way to use SAS programming to help on writing SAS procedure synta x to do statistical analysis