The power of using options COMPLETETYPES and PRELOADFMT
Naren Surampalli · 2012
As a statistical programmer in pharmaceutical industry, our job revolves around generating reports, which involve calculating counts and percentages across different treatments. To generate counts, most of us use procedures like frequency, sql etc., but these procedure doesn't display a missing group, if all the values of a particular group are missing in a data set. To display zeros for a missing group or treatment in our reports, we end up writing additional code, which is not very efficient. This paper will discuss a better way to count, handle missing values efficiently and show how to create totals and sub-totals easily using one or two steps.