我对单元格求和有问题。我不知道为什么,但当我尝试总结时,我只添加了一个表中的记录,即使另一个表中也有下面enter image description here照片中的记录
这是过期和活动的代码:
proc sql;
create table expired as
select
policy_vintage
,count(NRB) as EXPIRED
from PolisyEnd
where CREDIT = "W"
group by policy_vintage
;
quit;
proc sql;
create table active as
select
policy_vintage
,count(NRB) as ACTIVE
from PolisyEnd
where CREDIT = "A"
group by policy_vintage
;
quit;我想创建一些单独的表,每个表都有sum:
proc sql;
create table graphbar as
select
sum(ak.ACTIVE) as ACTIVE
,sum(wy.EXPIRED) as EXPIRED
from active ak
left join expired wy
on wy.expired= ak.active
;
quit;但是我得到了一些这样的东西,我不知道为什么enter image description here
发布于 2021-11-03 20:06:22
CREATE TABLE expired (
policy_vintage varchar(8) NOT NULL PRIMARY KEY,
EXPIRED int NOT NULL
);
CREATE TABLE active (
policy_vintage varchar(8) NOT NULL PRIMARY KEY,
ACTIVE int NOT NULL
);
SELECT e.EXPIRED, a.ACTIVE
FROM (
SELECT SUM(EXPIRED) AS EXPIRED FROM expired
) AS e
CROSS JOIN (
SELECT SUM(ACTIVE) AS ACTIVE FROM active
) AS ahttps://stackoverflow.com/questions/69830930
复制相似问题