PROC SQL没有正确连接字符串变量

Question

我有一个查询，我试图运行一个连接，它没有正确连接。查询如下:

PROC SQL;
CREATE TABLE indexscores AS
SELECT ready.varname, 
modules2.varlabel,
ready.mean AS ready, 
ecosocial.mean AS ecosocial, 
capacity.mean AS capacity, 
change.mean AS change,
SUM(ready.mean,ecosocial.mean,capacity.mean,change.mean) AS score
FROM ready
LEFT OUTER JOIN ecosocial ON ready.varname=ecosocial.varname
LEFT OUTER JOIN capacity ON ready.varname=capacity.varname
LEFT OUTER JOIN change ON ready.varname=change.varname
LEFT OUTER JOIN modules2 ON ready.varname=modules2.varname
GROUP BY ready.varname, modules2.varlabel, 
ready.mean, ecosocial.mean, capacity.mean, change.mean
ORDER BY ready.varname;
RUN;

下面是一个没有显示变量的示例

Obs varname varlabel  ready ecosocial  capacity change score 
1   airqual   3.0455 3.5000    3.0455    3.4545  13.05 
2   alcohol   2.7692 3.7500    2.8718    3.5897  12.98 
3   alctraff  3.2051 3.7500    3.2308    3.9474  14.13 

Answer 1

我认为在这种情况下您不需要group by子句，因为它会影响sum()函数。这是基于我的假设，您只是想要score中的行级和。