NUTs2 regions

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

Ambereerland
Posts: 2
Joined: Thu Sep 15, 2022 11:00 am

NUTs2 regions

Post by Ambereerland » Thu Sep 15, 2022 11:07 am

Hello,

I'm a student and trying to get some data about the EU patents applications for my master thesis. I want to create a dataset where the columns are the years '2016', '2017' and '2018'. And the rows are the NUTs2 regions, not specified to a country, but for the entire Europe. Can someone help me query? I keep getting errors if I try to create the NUTs2 rows.

Great thanks in advance!


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: NUTs2 regions

Post by EPO / PATSTAT Support » Sat Sep 17, 2022 9:34 pm

Can you post your SQL that gives errors ?
Assuming that your years are the year of filing or priority, you should look into CASE statements which is SQL's way of handling if/then logic.
See this forum note:
sql-queries-to-create-simple-applicant- ... able-10588
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply