Administrative Healthcare Data

Chapter 13: Extended Coding Examples

Introduction

Utility Macros

Age-As-Of Calculation

Identifying Sparse Variables

Arrays of Detail Record Elements on the Header Record

Linking to the Diagnosis Pointer

Conclusion

Introduction

This book is primarily about the business knowledge of administrative healthcare data. The more we know about the data, the more we will think of programmatic solutions to manage, analyze, and report this data.

We have shown example solutions in the context of the various chapters, but we were not able to address many useful—in our experience—tools and techniques. So we take this opportunity to share some extended coding examples. Some are presented as macros, while others are open-code solutions, with many possibilities ...