Calculation of the Co-Occurrence Matrix of Relational Data in Health&Hygiene Standards and Implementation by SAS Macro
Objective To design a solution path for the co-occurrence 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 Cj,k,export it as an out dataset,and further merge the dataset to form the final co-occurrence 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.