不是说好的Group只能和Having连用么???
有这样一个data set:
data Employee;
input EmpId$  Name $ Gender $ DepId  $ Salary  Bonus DOB;
informat DOB mmddyy8.;
format DOB date9.;
cards;
1400 Mary F ME1 29769 587 09/18/87
1403 Eric M ME3 28072 342 06/05/93
1120 Jenny F ME2 28619 986 03/27/95
1120 Jenny F ME2 28619 986 03/27/95
1156 Daniel M ME3 32619 523 07/12/92
1116 CiCi F ME2 46943 591 01/23/90
1131 Sophie F ME3 18745 537 11/14/93
1124 Steven M ME1 58376 935 08/28/96
1106 Ricky M ME3 36578 286 04/20/88
1234 Cindy F ME1 96465 275 12/06/94
;
run;
下面的coding没有报错,而且还出现了正是我想要的结果:
proc sql;
select gender, count(distinct EmpId) as N 
from Employee
where DOB between '01JAN1992'd and '31DEC1999'd
group by gender;
quit;
这是我最开始想写的coding:
proc sql;
select gender, count(distinct EmpId) as N 
from Employee
group by gender
having DOB between '01JAN1992'd and '31DEC1999'd;
quit;
可这段的结果却显示出了好几条!怎么就不是两条呢???
求指教,多谢多谢!!