卫生健康标准中关系型数据共现矩阵计算及SAS程序实现

Calculation of the Co-Occurrence Matrix of Relational Data in Health&Hygiene Standards and Implementation by SAS Macro

目的设计卫生健康标准中关系型数据共现矩阵的求解路径及其SAS实现方法。方法文章以计算一组标准的起草单位共现矩阵为例,将“标准-起草单位”二维表格导入SAS(版本号:9.4),按照“两两相乘”的计算思路自行设计宏程序计算起草单位之间的共现矩阵。结果以计算一组标准的起草单位共现矩阵为例,采用自行构建的模拟数据进行演示。首先,导入宏循环起始的数据集,并计算共现频次C_(j,k);然后,导出为out数据集,进一步合并数据集,形成最终的共现矩阵。结论SAS宏程序计算标准中关系型数据共现矩阵具有灵活高效的优势,可用于社会网络分析和互动演进规律总结。

Objective To design a solution path for the cooccurrence matrix of relational data in health&hygiene standards by SAS.Methods The paper takes the calculation of co-occurrence matrix of a group of standard drafting agency as an example,imports the two-dimensional table of"standard-drafting agency"into SAS(version No.:9.4),and designs a macro program to calculate the co-occurrence matrix between drafting agency according to the calculation of"pairings multiplication".Results Taking the calculation of the co-occurrence matrix of drafting agency for a set of standards as an example,a self-built simulation data is used for demonstration.Firstly,import the dataset at the beginning of the macro loop,then calculate the co-occurrence frequency C_(j,k),export it as an out dataset,and further merge the dataset to form the final cooccurrence matrix.Conclusion SAS macro program has the advantage of flexibility and efficiency in calculating the co-occurrence matrix of relational data,which can be used for social network analysis and interaction evolution exploration.