- data t2_;
- merge t2c t2n;
- by ord AEBODSYS AEDECOD AETOXGR;
- proc sort;
- *by AETOXGR;
- by AEBODSYS;
- run;
复制代码这段代码是没有填补之前,将例数例次进行了一个合并,然后得到的一个所有不良事件按严重程度分类的数据集t2_
- *根据t2_来获取每个分类,并为每个分类填补上等级;
- data PT;
- set t2_;
- keep AEBODSYS AEDECOD;
- proc sort nodup;
- by AEBODSYS AEDECOD;
- run;
- data PT;
- set PT;
- by AEBODSYS AEDECOD;
- array level[5] $5. level1-level5;
- do i=1 to 5;
- level[i] = put(i,level.);
- AETOXGR = level[i];
- *if AEDECOD = "" then delete;
- output;
- end;
- keep AEBODSYS AEDECOD AETOXGR;
- proc sort;
- by AEBODSYS AEDECOD AETOXGR;
- run;
复制代码使用数组,每个等级用数组保存下来,这个level格式为提前设置好,如下
- proc format;
- value level
- 1 = "1级"
- 2 = "2级"
- 3 = "3级"
- 4 = "4级"
- 5 = "5级"
- ;
- run;
复制代码最后进行一个合并
- data t2;
- merge PT t2_;
- by AEBODSYS AEDECOD AETOXGR;
- run;
复制代码结果如下