事实上,我是proc univarite一个分数字段的10分位数临界点,然后需要按照这10个临界点对分数做分组,我想直接引用这个数据,不想每次都要手动输入,尝试了sas数组,但还是没整好。
附上代码:
proc univariate data=cc.merge_psi_nocon; where dt=20181031; var b5score; output out=bin1 pctlpre=p pctlpts=10 to 90 by 10; run;
data cc.merge_psi_nocon; set cc.merge_psi_nocon; if b5score<=481 then fenzu=1; else if b5score<=534 then fenzu=2; else if b5score<=569 then fenzu=3; else if b5score<=598 then fenzu=4; else if b5score<=624 then fenzu=5; else if b5score<=649 then fenzu=6; else if b5score<=676 then fenzu=7; else if b5score<=708 then fenzu=8; else if b5score<=754 then fenzu=9; else fenzu=10; run;
其实我就是想把bin1里的481 534 569 ...直接引用下来