The Trauma Quality Improvement Project (TQIP) Data is national level health data available for use in researching traumatic injury. Using this data requires a large degree of data manipulation and calculation to properly investigate the leading questions in trauma research today. This presentation and paper provide ready to use code used to achieve triage evaluations, injury severity measures by region, shock index ratio, and frailty. These are hot topics in trauma research not pre-calculated in the data itself. To demonstrate its utility, a recently completed study will be used as an example. Code used to produce study outcomes will be evaluated for speed, reproducability, and ease of use. The coding concepts used in this solution are simple yet powerful: Primary Query Language: PROC SQL Macro Language Data Manipulation: PROC TRANSPOSE, Arrays, PROC FORMAT
Watch the recording
