sql子查詢的問題！

是 否 +2 論壇幣

k人 參與回答

經(jīng)管之家送您一份

應(yīng)屆畢業(yè)生專屬福利!

求職就業(yè)群

趙安豆老師微信：zhaoandou666

經(jīng)管之家聯(lián)合CDA

送您一個全額獎學(xué)金名額~ !

立即領(lǐng)取

感謝您參與論壇問題回答

經(jīng)管之家送您兩個論壇幣！

+2 論壇幣

原始數(shù)據(jù)集

SUBJID	AGERP	sex	arm
01-S001	30 to 39 years	Female	1
01-S003	40 to 49 years	Female	1
01-S005	60 years	Male	1
01-S007	60 years	Male	1
01-S009	40 to 49 years	Female	1
01-S011	60 years	Female	1
01-S013	60 years	Male	1
02-S001	40 to 49 years	Female	1
02-S003	50 to 59 years	Female	1
02-S005	50 to 59 years	Female	1
03-S002	60 years	Female	1
03-S004	40 to 49 years	Female	1
03-S006	50 to 59 years	Female	1
03-S008	30 to 39 years	Female	1
03-S010	50 to 59 years	Female	1
03-S012	60 years	Female	1
03-S014	50 to 59 years	Male	1
03-S016	50 to 59 years	Female	1
03-S018	30 to 39 years	Male	1
03-S020	40 to 49 years	Male	1
01-S002	60 years	Female	2
01-S004	60 years	Male	2
01-S006	60 years	Female	2
01-S008	40 to 49 years	Male	2
01-S010	50 to 59 years	Male	2
01-S012	40 to 49 years	Female	2
01-S014	50 to 59 years	Female	2
02-S002	60 years	Male	2
02-S004	60 years	Male	2
03-S001	50 to 59 years	Female	2
03-S003	40 to 49 years	Male	2
03-S005	60 years	Male	2
03-S007	50 to 59 years	Female	2
03-S009	40 to 49 years	Male	2
03-S011	50 to 59 years	Female	2
03-S013	40 to 49 years	Female	2
03-S015	40 to 49 years	Female	2
03-S017	30 to 39 years	Female	2
03-S019	40 to 49 years	Male	2
03-S021	60 years	Female	2

想通過sql建立一個table變成以下結(jié)果

age/sex	group	count
30 to 39 years	1	3
40 to 49 years	1	5
50 to 59 years	1	6
60 years	1	6
30 to 39 years	2	1
40 to 49 years	2	7
50 to 59 years	2	5
60 years	2	7
Male	1	6
Female	1	14
Male	2	9
Female	2	11

我的想法是：
proc sql;
        create table age_group as select arm,count(select AGERP,arm,count(SUBJID) from origin_1 group by AGERP,arm),count(select SEX,arm,count(SUBJID) from origin_1 group by SEX,arm) from origin_1 group by arm;
quit;

但是會報錯。
我知道可以分別對AGERP和sex建立兩個table，然后set到一起，但是我想知道能不能一次性做到，畢竟我覺得sql很強(qiáng)大！

掃碼加我 拉你入群

請注明：姓名-公司-職位

以便審核進(jìn)群資格，未注明則拒絕

分享0 收藏0 回帖

關(guān)鍵詞：sql 子查詢 proc sql Female Select

估計有難度  你把原始數(shù)據(jù)集先拆分 再set到一起 就可以只寫一個sql，group by 統(tǒng)一變量了  

proc sql;create table as
select ***
union
select ***;
quit;
可以嗎？

512002855 發(fā)表于 2016-12-23 18:03
proc sql;create table as
select ***
union

有意思！實(shí)際上就是做兩張表再合到一起！有時間試試！

你可以分開做兩張表