[程式] SAS找出同一ID，某欄位符合特定條件的row
[軟體程式類別]:
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
推
05/01 18:23, , 1F
05/01 18:23, 1F
→
05/01 18:23, , 2F
05/01 18:23, 2F
→
05/01 18:23, , 3F
05/01 18:23, 3F
→
05/01 18:23, , 4F
05/01 18:23, 4F
→
05/01 18:23, , 5F
05/01 18:23, 5F
→
05/01 18:23, , 6F
05/01 18:23, 6F
→
05/01 18:23, , 7F
05/01 18:23, 7F
→
05/01 18:23, , 8F
05/01 18:23, 8F
→
05/01 20:06, , 9F
05/01 20:06, 9F
推
05/01 21:24, , 10F
05/01 21:24, 10F
→
05/02 00:36, , 11F
05/02 00:36, 11F
→
05/02 00:38, , 12F
05/02 00:38, 12F
→
05/02 00:38, , 13F
05/02 00:38, 13F