Hi all, I am using PATSTAT 2017 Autumn version. I have a list of publication number kept in excel file and I want to extract IPC codes associated with those publication numbers. But the problem is that this list contains approximate 8000 unique publication numbers. Its very time consuming for me to...

Updated: Added scripts for Patstat 2017 Autumn Edition

Hi, I think you should first try to understand how to use the "group by" clause, for example by looking at http://www.zentut.com/sql-tutorial/sql-group-by/ or even youtube videos, that might be more begginer-friendly (https://www.youtube.com/watch?v=E3rXVrTTROU). Then, about your query... I didn't v...

I was told that this issue is not going to be fixed for current PATSTAT version (but 2017 Spring will be fine).
So, I've manually removed some duplicated entries and set all this values to 'U' - as for 'Unknown'.



Regards,

Hi, As far as I I can see, these 78 cases have already been corrected in our source databases, so you will not find them e.g. in Espacenet, and they will also not show up in the next PATSTAT edition. Hi Martin, I guess some fix should be released for current PATSTAT edition as well... will you take...

Hi, I've just detected some weird values in the TLS215_CITN_CATEG table... some CITN_CATEG values are "Ãœ" (" Ü " in UNICODE), but I can't find this value in the documentation: CITN_CATEG 6.22 Name: Category of the citation Also Known As: n/a Description: Category of the citation as mentioned in Sea...

Hi, I'm sharing the scripts I wrote for loading PATSTAT into ORACLE. Please try and give some feedback, I hope it works well for you. PATSTAT 2016 SPRING Edition: http://s000.tinyupload.com/?file_id=37947315639578337902 PATSTAT 2016 AUTUMN Edition: http://s000.tinyupload.com/?file_id=602982435450815...