the number of forward citation

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Darwin
Posts: 2
Joined: Tue Jun 12, 2018 6:30 pm

the number of forward citation

Post by Darwin » Wed Jun 13, 2018 11:36 am

Hello all,

For research work, I would like to count the number of forward citation of companies' patent per company per year. And at current stage, I would like to show all distinct PAT_PUBLN_ID based on same EARLIST_APPLN_ID by using following codes,

Code: Select all

SELECT 
   tls201_appln.earliest_filing_id,
   distinct (case when earliest_filing_id = earliest_filing_id then pat_publn_id end)
from tls201_appln 
join tls212_citation on tls201_appln.appln_id = tls212_citation .cited_appln_id
join tls211_pat_publn on tls201_appln.appln_id =  tls211_pat_publn.appln_id
where applt_seq_nr > 0
and publn_date = 2000
group by earliest_filing_id
order by earliest_filing_id
but the result shows a syntax error. Could you please give me some suggestion about this. thanks in advance.


Post Reply