[程式] SAS找出同一ID，某欄位符合特定條件的row

[faceoflove56 (1234567)]

[軟體程式類別]:
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://www.ptt.cc/bbs/Statistics/M.1430470489.A.BBC.html
推 anniecs: proc sql;
→ anniecs: create table new_data as
→ anniecs: select name, role
→ anniecs: from old_data
→ anniecs: where name in (select name from old_data group by nam
→ anniecs: e having count(distinct role)>1);
→ anniecs: quit;
→ anniecs: 怎樣散成這樣><
→ MOONY135: count就好了吧
推 imaltar: 要放distinct 不然會全選到, 除非Ken只有一筆
→ faceoflove56: 感謝樓上各位前輩，順便問一下各位是否有好用的SAS
→ faceoflove56: 入門書可推薦，目前都是上網查語法，SAS架構還不清
→ faceoflove56: 楚