【sas proc sql】引用计算产生的列

在proc sql中引用计算产生的列，前面必须加上calculated

例如

proc sql outobs=5;
    title 'this is an example of sql and outobs';
    select wangnei,date,'test','测试',wangnei+1 as wang,wangnei+10 as wanga,(calculated wang+calculated wanga) as wangb
    from mysas.mmsone
    where date<200905
    order by wangnei desc;
quit;

注意，两个计算生成的变量前面都要加上calculated