【sas sql proc】proc sql; quit;

proc sql 是以quit结束，而非run

proc print data=mysas.mmsone (obs=10);
run;
proc sql;
    title 'this is an example of proc sql';
    select sum(wangnei) as a,date
    from mysas.mmsone
    where date<200904
    group by date
    having date in(200901,200902)
    order by a desc;
quit;

注意having的用法。

稍微改进一下，可以只显示部分结果。

proc sql outobs=5;
    title 'this is an example of sql and outobs';
    select wangnei,date
    from mysas.mmsone
    where date<200905
    order by wangnei desc;
quit;
proc sql;
    describe table mysas.mmsone;
quit;

注意 describe table 和proc contents 功能类似。

 

proc sql outobs=5;
    title 'this is an example of sql and outobs';
    select wangnei,date,'test','测试'
    from mysas.mmsone
    where date<200905
    order by wangnei desc;
quit;

在sql查询中可以直接加入文本在每一行中，测试显示，sas9.2 英文环境下不支持中文。