求助：如何引用固定观测中固定变量的值？

shiyiming

假设有一10观测的数据集raw中有变量stu_Id score scr_mean，要对每个观测中的score值与scr_cmp进行比较生成变量eva，而变量scr_cmp除了最后一个观测非空外，其他都是缺失值，请问如何进行比较，若大于比较值，则变量eva的值为'优',否则为'良'。谢谢！！！
程序：
data score;
     input Stu_Id score scr_cmp;
cards;
1 88 .
2 80 .
3 75 .
4 68 .
5 90 .
6 77 .
7 82 .
8 81 .
9 85 .
10 89 85
;
run;

shiyiming

[code:1hb930i0]proc sql;
        create table out as
                select stu_id,score,max(scr_cmp) as scr_cmp,
                                case
                                        when score gt calculated scr_cmp then '优'
                                        else '良'
                                end as eva
                        from score;
quit;[/code:1hb930i0]

shiyiming

谢谢 <!-- s:D --><img src="{SMILIES_PATH}/icon_biggrin.gif" alt=":D" title="Very Happy" /><!-- s:D -->

shiyiming

DATA OUT;
SET SCORE(IN=A KEEP=SCR_CMP)
      SCORE(IN=B);
RETAIN CMP 0;
IF A THEN DO;
IF CMP LE SCR_CMP THEN CMP=SCR_CMP;
END;
IF B;
IF SCORE GT CMP THEN EVA=&quot;优&quot;;
ELSE EVA=&quot;良&quot;;
KEEP STU_ID SCORE CMP EVA;
RUN;

shiyiming

答案站内短消息于你，请注意查收！