来人看看 SAS-经管之家官网！

表Store:
Store_id(pk) City Space
wh1 New York 370
wh2 Beijing 500
wh3 New York 200
wh4 London 400
表Employee:
Store_id(fk) Emp_ID(pk) Salary
wh1 e1 1220
wh1 e3 1210
wh2 e4 1250
wh2 e6 1230
需要得到结果：每个城市的 总Salary,总Space,在Store表中数量，在Employee表中数量，最大Salary 得出结果如下：
City Tot.Salary Tot.Space #Store #Employee Max Salary
New York 2430(1220+1210) 570(370+200) 2 2 1220
Beijing 2480(1250+1230) 500 1 2 1250
London . 400 1 0 .

1. data one;
   
2. input Store_id $ City $ Space;
   
3. cards;
   
4. wh1 New.York 370
   
5. wh2 Beijing 500
   
6. wh3 New.York 200
   
7. wh4 London 400
   
8. ;
   
9. data two;
   
10. input Store_id $ Emp_ID $ Salary;
    
11. cards;
    
12. wh1 e1 1220
    
13. wh1 e3 1210
    
14. wh2 e4 1250
    
15. wh2 e6 1230
    
16. ;
    
17. proc sort data=one;
    
18. by Store_id;
    
19. proc sort data=two;
    
20. by Store_id;
    
21. data total;
    
22. merge one two;
    
23. by Store_id;
    
24. data total1;
    
25. set total;
    
26. 
    
27. proc sql;
    
28. select City,sum(salary) as totsalary ,count(Emp_id) as Employee,max(salary)from total1group by City ;
    
29. run;

复制代码
我现在只能查询出
The SAS System
City totsalaryEmployee
儍儍儍儍儍儍儍儍儍儍儍儍儍儍儍儍儍儍儍?
Beijing 2480 2 1250
London . 0 .
New.York 2430 2 1220
如果加上其他的选项的话就会狂出问题，谁能告诉我应该怎么做这个？？？
谢谢