SQLで以下の構文を記載するとkey変数の重複がでます。
どこが間違っているでしょうか?
group byするとkey変数における重複はなくなるとの想定でしたが・・・・
以下の文で記載すると、Xの重複ができてしまいます。。。
proc sql;
create table B as /★JOIN★/
SELECT
unikey2
,MAX(CASE WHEN t1.ke_Zokugara_1 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_1
,MAX(CASE WHEN t1.ke_Zokugara_0 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_0
,MAX(CASE WHEN t1.ke_Zokugara_2 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_2
,MAX(CASE WHEN t1.ke_Zokugara_3 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_3
,MAX(CASE WHEN t1.ke_Zokugara_4 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_4
,MAX(CASE WHEN t1.ke_Zokugara_5 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_5
,MAX(CASE WHEN t1.ke_Zokugara_6 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_6
,MAX(CASE WHEN t1.ke_Zokugara_7 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_7
,MAX(CASE WHEN t1.ke_Zokugara_8 = 1 THEN 1 ELSE 0 END) AS ke_Zokugara_8
,MAX(CASE WHEN t1.ke_Zokugara_9= 1 THEN 1 ELSE 0 END) AS ke_Zokugara_9
,SUM(CASE WHEN t1.ke_shushin_sum = 1 THEN 1 ELSE 0 END) AS ke_shushin_sum
,ke_yourou_sum
,ke_iryo_sum
,ke_nenkin_sum
FROM A as t1
Group by X
;
QUIT;
回答2件
あなたの回答
tips
プレビュー