Hi statalist,

I have shown a sample of my dataset below. I want to make a merging with the other dataset shown. I have the problem that when I try to make the merge 1:m using ipe, which is the only variable I can merge, it wouldn't let me do it since there are multiple ipc but I can't remove duplicates since the rest of the information is not the same. How would you do the merge?

My dataset:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str12 cvr long family_id str14 ipc
"39406101"    16174003 "A01B   3/46" 
"10600278"   317294779 "A01B  15/06" 
"39406101"     9036923 "A01B  23/02" 
"76242917"    15559142 "A01B  23/02" 
"73386810"    15466238 "A01B  33/06" 
"29979812"    21524963 "A01B  39/18" 
"34487936"   437642559 "A01B  43/00" 
"40986642"    13457647 "A01B  59/042"
"41852119"    15263341 "A01B  59/043"
"55274517"     2216783 "A01B  63/00" 
"35152113"   448838269 "A01B  63/00" 
"35152113"   456775340 "A01B  63/10" 
"25814363"    13074605 "A01B  63/10" 
"36942975"   473967732 "A01B  63/10" 
"36942975"   473967731 "A01B  63/114"
"17439588"    15467133 "A01B  63/32" 
"46099117"    11288040 "A01B  63/32" 
"15334800"   380624573 "A01B  69/00" 
"36942975"   484453037 "A01B  69/00" 
end
The dataset I want to merge with:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str13 ipc str25 tech1
"A01B   3/46"  "alternative energy"
"A01B  23/02"  "alternative energy"
"A01B  23/02"  "alternative energy"
"A01B  39/18"  "alternative energy"
"A01B  63/32"  "alternative energy"
"A01B  63/32"  "alternative energy"
"A01B  63/32"  "alternative energy"
"A01B  63/32"  "alternative energy"
"A01B  63/114"  "alternative energy"
"A01B  63/114"  "alternative energy"
end
Thanks in advance!