SAS问题有人知道么

[YZ7891]

以前没有学过SAS，拜托懂的人教下，比如我的SQL语言：
select city,sum(employee.salary),sum(space),count(city),count(employee.salary),max(employee.salary)
from store inner join employee
on
store.store_id=employee.store_id
group by city;
这个查询语句用SAS表现出来是怎么写的？我这么写对不对：
proc sql;
create table kids3 as
select city,sum(employee.salary),sum(space),count(city),count(employee.salary),max(employee.salary)
from store inner join employee
on
store.store_id=employee.store_id
group by city;
quit;
proc print data=kids3 noobs;
run;

对不对…… 这个是我在网上找的……然后自己乱加上去的……

[mynameis_007]

我是来帮忙顶顶的

[systemthink]

找个SAS编程看看

[rayjava]

建议你先merge俩datasets, then aggregate by group.

[BriskJJ]

你好，怎么用JDBC连接SAS的数据库呀？能给我介绍一下吗？
我的邮箱;[e-mail]