I want to calculate the radicalness of patents, so I am working with the backward citation. To calculate the radicalness of patents I am using the OECD radicalness index, which is shown in the figure below. The radicalness of a patent is calculated by dividing the number of IPC codes by the number of all citations.
Array
I am working with the IPC classification data of patentsview and I am merging this dataset with the US patent citation data of patentsview to calculate the radicalness. The problem is that the IPC dataset gives multiple IPC codes for one patent_id. Therefore I can not merge the dataset with the us patent citation dataset. I need to have one IPC code for every patent, How can I achieve this? Attached is a part of my dataset of the IPC codes. I already did drop some variables which are not needed in the analysis. When I can merge the dataset with the US patent citation, I can calculate the radicalness. see picture below for a part of the data, which shows the problem.
Thanks in advance.
Array
Related Posts with Merging us patentsview with IPC codes, multiple ipc codes for one patent_id
Mac STATA graph errorHello, I am running STATA 16 on my mac with BigSur. For some reason, STATA (updated today) will no l…
Within-between estimator with a lagged dependent variableHey, I have some CSTS data. I wish to use the "within-between" random effects estimator (Bell and J…
Creating a dynamic portfolio of returnsDear Statalist members, I am using Stata for the first time for my Masters Thesis and have tried to…
How to create drug classification variable using generic drug name variableHello. I am research student that is new to STATA and I am trying to learn how to create a drug clas…
stata evenstudy2 packageI use stata SE 14.2 version to do event study analysis. I'm using eventstudy2 package, but always so…
Subscribe to:
Post Comments (Atom)
0 Response to Merging us patentsview with IPC codes, multiple ipc codes for one patent_id
Post a Comment