Welcome
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 private consulting work.
Excel to SAS
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.

