Doug Theriaque

Thanks for dropping by. You'll find information here about me and my work as well as SAS programming code. These have been taken from my long-standing work at the University of Florida Health Science Center and from my consulting work and are being provided to the research community and general public for the first time.

Note: This example does NOT contain actual subject data.

It's not unusual in small pilot studies that investigators use Microsoft Excel to manage their data. I see this in about 30% of the projects I work on. It's also not unusual that principal investigators (PIs) or their staff choose interesting ways in which to format their data in Excel.

As an example, I often receive datasets that are formatted in what I call a "log format". Here, each subject's data is placed within one tab in excel and the data are formatted in the style of a report.