04 NIS 2002-2011 Procedural Classification

<br>Jordan A. Kempker, MD, MSc July 12, 2016 Assignment of Procedural Classes The HCUP creates and annually updates a categorization of the &gt;3,900 ICD-9 Procedures into 4 class: 1. Minor Diagnostic 2. Minor Therapeutic 3. Major Diagnostic 4. Major Therapeutic This is stored in pc2015.csv availabe for download from their website. This .CSV file contains a procedure code, a label and a procedure class assignment. In excell I deleted first 3 rows of description, added a first column with "if procedure[i] = ", replaced the third column with "then prclass [i] = " and added a fourth column with a semicolon. I then copy and pasted entire table into code below to create a massive IF-THEN code chunk for the two ARRAYS. (Use 'Control + Page Down' to get to the next code chunk) Then to create an OR Procedure Variable, I followed HCUP documentation that PRCLASS of 3 or 4 corresponds to an OR PROCEDURE. Used another ARRAY for this.