SAS程序员测试（一）

shiyiming

[code:2nlx9562]data ahuige;
    input  Card  $ Charge ;
    cards;
A123 14.56
A123 15.23
A123  -14.56
A234 11.12
A234 3.87
A234 11.12
A234  -11.12
A234 4.86
;
run;

proc sql;
    create table final as
    select card,charge
    from ahuige(where=(charge>0))
    except all
    select card,abs(charge) as charge
    from ahuige(where=(charge<0))
    ;
[/code:2nlx9562]
突然发觉自己以前从来没有回过这个贴子。。。。。。。。。。。。。。

shiyiming

哏多方法，看得老汉眼发花！