作者faceoflove56 (1234567)
看板Statistics
标题[程式] SAS找出同一ID，某栏位符合特定条件的row
时间Fri May 1 16:54:46 2015
[软体程式类别]:
SAS
[程式问题]:
资料处理
[软体熟悉度]:
低(1~3个月)
[问题叙述]:
Name Role
----------------
Jack Chairman
Jack Member
Jack Member
Ken Member
Ken Member
Rick Chairman
Rick Chairman
Rick Member
Tom Chairman
Tom Chairman
Tom Member
若有一人为Chairman，则在资料里他同时也为Member，但这样导致资料重复
我想知道有多少笔资料出现这种情况，若某人Role栏位同时为Chairman和Member则output
Name Role
----------------
Jack Chairman
Jack Member
Jack Member
Rick Chairman
Rick Chairman
Rick Member
Tom Chairman
Tom Chairman
Tom Member
[程式范例]:
想不出来该如何下手...感谢各位前辈指教
-----------------------------------------------------------------------------
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 140.119.120.6
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Statistics/M.1430470489.A.BBC.html
1F：推 anniecs: proc sql; 05/01 18:23
2F：→ anniecs: create table new_data as 05/01 18:23
3F：→ anniecs: select name, role 05/01 18:23
4F：→ anniecs: from old_data 05/01 18:23
5F：→ anniecs: where name in (select name from old_data group by nam 05/01 18:23
6F：→ anniecs: e having count(distinct role)>1); 05/01 18:23
7F：→ anniecs: quit; 05/01 18:23
8F：→ anniecs: 怎样散成这样>< 05/01 18:23
9F：→ MOONY135: count就好了吧 05/01 20:06
10F：推 imaltar: 要放distinct 不然会全选到, 除非Ken只有一笔 05/01 21:24
11F：→ faceoflove56: 感谢楼上各位前辈，顺便问一下各位是否有好用的SAS 05/02 00:36
12F：→ faceoflove56: 入门书可推荐，目前都是上网查语法，SAS架构还不清 05/02 00:38
13F：→ faceoflove56: 楚 05/02 00:38