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.Jordan A. Kempker, 医学博士、理学硕士 2016年7月12日 手术类别分配 医疗成本与利用项目（Healthcare Cost and Utilization Project, HCUP）每年都会对超过3900条ICD-9手术操作代码进行分类，将其划分为4个类别： 1. 诊断类小操作 2. 治疗类小操作 3. 诊断类大操作 4. 治疗类大操作 该分类结果存储于pc2015.csv文件中，可从HCUP官方网站下载获取。此CSV文件包含操作代码、操作标签及手术类别分配结果。 本人在Excel中删除了该文件前3行的说明文本，新增首列内容为"若操作[i] = "，将第三列替换为"则prclass[i] = "，并新增第四列内容为分号";"。随后将整个表格复制粘贴至下方代码中，为两个数组生成了大量IF-THEN代码块（可使用"Ctrl+PageDown"快捷键跳转至下一个代码块）。 为创建手术操作变量，本人参考HCUP官方文档，将PRCLASS值为3或4的操作归类为手术室手术操作（OR PROCEDURE），并通过另一个数组实现了该功能。