我有一個個人資料集，每個人都有自己唯一的 ID。我們有關于他們在 3 種不同環境中與誰互動的資訊：在學校、課間和校外。個人參考的人員串列存盤為一個字串，每個元素用逗號分隔。
我已經用過
split, destring
命令為在每種情況下參考的每個朋友創建一個唯一變數。
clear
input int user_id strL coop_friends_list_1 int(RecessFriend1 RecessFriend2 RecessFriend3 RecessFriend4) strL liste_amis int(CloseFriend1 CloseFriend2 CloseFriend3 CloseFriend4)
79 "81, 80, 93, 92, 87, 94, 89, 88, 83, 84, 97" 81 80 93 92 "81, 92, 94, 83, 80, 88, 87" 81 92 94 83
80 "82, 83, 89, 88, 93, 92, 87, 81, 97, 84" 82 83 89 88 "81, 92" 81 92 . .
81 "82, 89, 93, 92, 87, 88, 79, 84, 80, 97, 83" 82 89 93 92 "80, 87, 92, 82, 88, 93, 98, 94, 89, 83, 85, 90, 95, 91, 96, 86, 79" 80 87 92 82
82 "80, 81, 87, 92, 93, 97" 80 81 87 92 "80, 81, 86, 87, 88, 89, 92, 93, 94, 97, 98" 80 81 86 87
83 "92, 80, 87, 81" 92 80 87 81 "87, 80, 92, 81" 87 80 92 81
84 "92, 97, 82, 87, 88, 93, 89, 80, 79, 83" 92 97 82 87 "91, 80, 90" 91 80 90 .
85 "95, 98, 94, 91, 86, 90, 96" 95 98 94 91 "95, 90, 98, 96, 91, 86, 93, 88, 82, 89" 95 90 98 96
86 "94, 96, 85, 91, 98, 95, 90" 94 96 85 91 "98, 85, 89, 82, 93" 98 85 89 82
87 "83, 81, 92, 88, 89, 93, 82, 80, 79, 84, 94" 83 81 92 88 "83" 83 . . .
88 "80, 81, 84, 87, 89, 92, 93, 94" 80 81 84 87 "84, 87, 80, 94, 89" 84 87 80 94
end
我想創建一個計數器來計算重復的實體：在上課時間的同伴串列中，有多少人在課外時間也被參考，每個人。
uj5u.com熱心網友回復：
* Example generated by -dataex-. To install: ssc install dataex
clear
input int user_id strL(coop_friends_list_1 liste_amis)
79 "81, 80, 93, 92, 87, 94, 89, 88, 83, 84, 97" "81, 92, 94, 83, 80, 88, 87"
80 "82, 83, 89, 88, 93, 92, 87, 81, 97, 84" "81, 92"
81 "82, 89, 93, 92, 87, 88, 79, 84, 80, 97, 83" "80, 87, 92, 82, 88, 93, 98, 94, 89, 83, 85, 90, 95, 91, 96, 86, 79"
82 "80, 81, 87, 92, 93, 97" "80, 81, 86, 87, 88, 89, 92, 93, 94, 97, 98"
83 "92, 80, 87, 81" "87, 80, 92, 81"
84 "92, 97, 82, 87, 88, 93, 89, 80, 79, 83" "91, 80, 90"
85 "95, 98, 94, 91, 86, 90, 96" "95, 90, 98, 96, 91, 86, 93, 88, 82, 89"
86 "94, 96, 85, 91, 98, 95, 90" "98, 85, 89, 82, 93"
87 "83, 81, 92, 88, 89, 93, 82, 80, 79, 84, 94" "83"
88 "80, 81, 84, 87, 89, 92, 93, 94" "84, 87, 80, 94, 89"
end
// Create a local macro containing all user id's
numlist "1/100"
local all_users = r(numlist)
gen wanted = 0
foreach user of local all_users {
replace wanted = wanted (ustrregexm(coop_friends_list_1, "\b`user'\b") & ustrregexm(liste_amis, "\b`user'\b"))
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/452143.html