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.