Proc Sql ;
Create Table Class As
Select
Name,
Case When Sex Eq "M" Then "1"
When Sex Eq "F" Then "2"
Else "3"
End
As Sex_Tran Label="性别转换",
Sum((Weight-20)) As New1 Format=16.2,
Mean((Height-10)) As New2 Format=16.2,
(Calculated New1-Calculated New2) As New
From Sashelp.Class(Where=(Height Between 50 And 70))
Group By Name,Calculated Sex_Tran
Order By Calculated Sex_Tran Desc
;
Quit;
一般情况我们写完一个语句,就会有一个分好,可是该程序知道Quit之前才有一个分好,不会特别理解。比如说上面的END,后面为什么不加分好呢?还有其他的语句。