PROC SQL 排序问题请教?
以下代码:
data new;
input codenumber :$10. liaoping $;
datalines;
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PD
CHN001002 SD
CHN001002 PD
run;
proc sql;
select * from new
order by codenumber;
quit;
输出结果如下:
codenumber liaoping
CHN001001 PR
CHN001001 PD 这个PD为啥会跑到这里来?
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001001 PR
CHN001002 PD
CHN001002 SD
依据变量codenumber排序,但是在同codenumber下liaoping变量的顺序也变了,对于CHN001001变量来说,liaoping变量中的PD怎么就排在了第三个,真是想不通,望哪位大神可以指导一下?