Question: how to merge PATSTAT with Orbis
Posted: Sun Jul 26, 2020 4:23 pm
Dear community,
is it possible to merge PATSTAT with Orbis?
I saw that the variable tls206_person.han_harmonized report whether the name tls206_person.han_name of the applicant has been armonizes to be matched with Orbis. I would have guessed that it is possible to merge the datasets using tls206_person.han_name and possibly tls206_person.han_id.
However, after inspecting some examples, it looks like there is no perfect match between names in Orbis and those obtained from tls206_person.han_name, as usually there is at least some letters or abbreviations that differ between the two sources.
Is there a proper/standard way to merge the dataset?
How about tls206_person.doc_std_name and tls206_person.psn_name? What's the difference with respect to han and could those be used too in the merge?
Thanks!
Luca
is it possible to merge PATSTAT with Orbis?
I saw that the variable tls206_person.han_harmonized report whether the name tls206_person.han_name of the applicant has been armonizes to be matched with Orbis. I would have guessed that it is possible to merge the datasets using tls206_person.han_name and possibly tls206_person.han_id.
However, after inspecting some examples, it looks like there is no perfect match between names in Orbis and those obtained from tls206_person.han_name, as usually there is at least some letters or abbreviations that differ between the two sources.
Is there a proper/standard way to merge the dataset?
How about tls206_person.doc_std_name and tls206_person.psn_name? What's the difference with respect to han and could those be used too in the merge?
Thanks!
Luca