Search found 20 matches

by Fr3dY
Fri Jun 08, 2018 2:47 pm
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 2654

Re: Only 30% person_address available?

OK, thanks!!
by Fr3dY
Fri May 18, 2018 9:42 am
Forum: PATSTAT Product Line
Topic: Only 30% person_address available?
Replies: 2
Views: 2654

Only 30% person_address available?

Hi, Just wanted to verify if only about 30% of person addresses are available (for RAW data): select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and person_address is not null; 3.653.560 select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and pers...
by Fr3dY
Tue Apr 24, 2018 3:22 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 14
Views: 12379

Re: PATSTAT - ORACLE loading scripts

Update: Added scripts for Patstat 2018 Spring Edition
by Fr3dY
Tue Feb 20, 2018 9:56 am
Forum: PATSTAT Product Line
Topic: Import data from excel - PATSTAT 2017 Autumn
Replies: 2
Views: 2906

Re: Import data from excel - PATSTAT 2017 Autumn

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...
by Fr3dY
Tue Oct 31, 2017 4:12 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 14
Views: 12379

Re: PATSTAT - ORACLE loading scripts

Updated: Added scripts for Patstat 2017 Autumn Edition
by Fr3dY
Tue May 16, 2017 10:49 am
Forum: PATSTAT Product Line
Topic: problems with "group by" in my query
Replies: 1
Views: 1198

Re: problems with "group by" in my query

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...
by Fr3dY
Tue Dec 13, 2016 2:43 pm
Forum: PATSTAT Product Line
Topic: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?
Replies: 3
Views: 1394

Re: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?

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,
by Fr3dY
Tue Dec 13, 2016 11:31 am
Forum: PATSTAT Product Line
Topic: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?
Replies: 3
Views: 1394

Re: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?

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...
by Fr3dY
Fri Dec 09, 2016 9:56 am
Forum: PATSTAT Product Line
Topic: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?
Replies: 3
Views: 1394

PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?

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...
by Fr3dY
Mon Oct 17, 2016 3:31 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 14
Views: 12379

PATSTAT - ORACLE loading scripts

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. [Old versions available on demand] PATSTAT 2020 SPRING Edition: https://www.filehosting.org/file/details/868372/PATSTAT2020A_OracleScripts.zip PATSTAT 2020 AUTUMN Edi...