01 NIS 2002-2011 Within Year Merge
收藏资源简介:
NIS 2002-2011 Within Year Merge - Each year of the NIS has a Core, Hospital and Severity file: FileLevelID CoredischargeKEY, HOSPID HospitalhospitalHOSPID SeveritydischargeKEY, HOSPID 1. The 2 dischrage-level files will trimmed down to desired variables and then merged by KEY and saved into a temporary SAS dataset. 2. The hospital file will be trimmed and then merged into the core-severity and saved into a permanent SAS dataset with following notation: NIS_YYYY 3. Working directory cleared after every year since very large datasets.
NIS 2002-2011年度内合并数据集——NIS各年度数据集均包含核心文件、医院文件与严重程度文件,各文件关键字段配置如下:核心文件对应出院关键字段(CoredischargeKEY)与医院标识符(HOSPID),严重程度文件对应严重程度出院关键字段(SeveritydischargeKEY)与医院标识符(HOSPID),医院文件对应医院ID(hospitalHOSPID)。 1. 两份出院层级文件将先筛选至所需变量,随后通过KEY关键字段进行合并,并存储为临时SAS数据集。 2. 医院文件将完成变量筛选后,合并至核心-严重程度合并文件中,最终以`NIS_YYYY`的命名格式存储为永久SAS数据集。 由于单年度数据集体量较大,每完成一个年度的处理流程后将清空工作目录。



