Hello Dear All,

I have been working on the Web of Science database and it contains author names and addresses. Here is an example created by the dataex

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str23 author strL address
"Abbasoglu Ozgoren, Ayse" "[Abbasoglu Ozgoren, Ayse; Ergocmen, Banu] Hacettepe Univ, Inst Populat Studies, Ankara, Turkey; [Tansel, Aysit] Middle East Tech Univ, Ankara, Turkey"
"Tansel, Aysit"           "[Abbasoglu Ozgoren, Ayse; Ergocmen, Banu] Hacettepe Univ, Inst Populat Studies, Ankara, Turkey; [Tansel, Aysit] Middle East Tech Univ, Ankara, Turkey"
end
As you could see there are two variables one for author one for address. However, inside of the address variable, there are more than one address because of the other authors. Therefore, I want to take for example the University conditional on the author name. As for my example, for Abbasoglu Ozgoren, Ayse, I want to have Hacettepe Univ, for Tansel, Aysit, I want to have Middle East Tech Univ.

Here is the last results I would like to create from the above example:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str23 author strL address
"Abbasoglu Ozgoren, Ayse" "Hacettepe Univ"      
"Tansel, Aysit"           "Middle East Tech Univ"
end

Thank you so much