TLS229_APPL_NACE2
Posted: Tue Jun 11, 2019 12:47 pm
Hi all,
I am a new user of PATSTAT and I need to extract patent data in the NACE2 codification. I have 3 questions :
1. I already find the Eurostat guide concerning the Concordance IPC V8 – NACE REV.2 but the problem I encounter is that there is no concordance for 4 digits NACE codes. Please could you send me a 4 digit detailed and updated NACE-IPC concordance table that I could use to do my queries?
2. 1. The main problem I encounter is to create and insert the section for the NACE sectors in SQL : please could you give me an example or model for extracting data with the NACE codes (2 sectors at least) with the TLS229_APPLN_NACE2 (4 digits details), please (in SQL language)?
3. How could I use the "weight" function in order to not have redundancies in my final results that are classified with the NACE codification?
Thank you in advance for your help
Best regards
Christelle
I am a new user of PATSTAT and I need to extract patent data in the NACE2 codification. I have 3 questions :
1. I already find the Eurostat guide concerning the Concordance IPC V8 – NACE REV.2 but the problem I encounter is that there is no concordance for 4 digits NACE codes. Please could you send me a 4 digit detailed and updated NACE-IPC concordance table that I could use to do my queries?
2. 1. The main problem I encounter is to create and insert the section for the NACE sectors in SQL : please could you give me an example or model for extracting data with the NACE codes (2 sectors at least) with the TLS229_APPLN_NACE2 (4 digits details), please (in SQL language)?
3. How could I use the "weight" function in order to not have redundancies in my final results that are classified with the NACE codification?
Thank you in advance for your help
Best regards
Christelle