SQL语法请教

shiyiming

明了你到是算
简洁可能还是算我的吧
呵呵呵 <!-- s:oops: --><img src="{SMILIES_PATH}/icon_redface.gif" alt=":oops:" title="Embarassed" /><!-- s:oops: -->

shiyiming

proc sql ;
create table WORK.CLASS as
    select * from SASHELP.CLASS where WEIGHT&gt;=112 order by age desc
   union
   select * from SASHELP.CLASS where WEIGHT&lt;112  order by age desc;
quit;

shiyiming

proc sql noprint;
   create table CLASS0 as
   select * from SASHELP.CLASS
   order by WEIGHT&gt;=100 desc, age desc;
quit;

shiyiming

proc sql ;
create table WORK.CLASS as
    select *,1 as team from SASHELP.CLASS where WEIGHT&gt;=112
   union
   select * ,2 as team from SASHELP.CLASS where WEIGHT&lt;112
   order by team,age desc;
quit;

shiyiming

Mark