我對單元格求和有問題。我不知道為什么，但是當我嘗試總結時，我只從一張表中添加記錄，即使另一張也有如下圖所示的記錄 在 此處輸入圖片描述
這是 expired 和 active 的代碼：
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;
我想創建一些單獨的表格，每個表格的總和：
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;
但我有一些類似的，我不知道為什么 在這里輸入影像描述
uj5u.com熱心網友回復：
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 a
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/346745.html
上一篇：Matlab腳本：顯示我的Simulink模型的輸出
下一篇：雪花-日期表過濾問題