04 NIS 2002-2011 Procedural Classification

Jordan A. Kempker, MD, MSc July 12, 2016 Assignment of Procedural Classes The HCUP creates and annually updates a categorization of the >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.