Search found 26 matches
- Thu Oct 31, 2019 10:36 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Added scripts for PATSTAT 2019 Autumn Edition
- Mon Jul 08, 2019 8:08 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Hi,
Those scripts are already available in the main post, could you take a look again?
Regards,
Those scripts are already available in the main post, could you take a look again?
Regards,
- Wed Jun 26, 2019 12:34 pm
- Forum: PATSTAT Product Line
- Topic: Now available: EP full-text data for analytics
- Replies: 2
- Views: 7850
Re: Now available: EP full-text data for analytics
Hi,
Where's the free dataset, available for download from Google Cloud Platform? Couldn't find the link, do I have to specifically request it? And what about these Google fees?
Regards,
Where's the free dataset, available for download from Google Cloud Platform? Couldn't find the link, do I have to specifically request it? And what about these Google fees?
Regards,
- Fri May 17, 2019 3:49 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Update: Added scripts for PATSTAT 2019 Spring Edition
- Thu Feb 21, 2019 9:11 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Good Mornings, There is a different way to receive PATSTAT 2018 AUTUMN Edition - Oracle Script , such as e-mail? It is impossible for me to download it from tinyupload for security reasons. The TinyUpload.com site is blocked by our proxy due to its poor reputation. Regards. Hi, Send me a private me...
- Mon Nov 12, 2018 5:16 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Update: Added scripts for Patstat 2018 Autumn Edition
- Fri Jun 08, 2018 2:47 pm
- Forum: PATSTAT Product Line
- Topic: Only 30% person_address available?
- Replies: 2
- Views: 3129
Re: Only 30% person_address available?
OK, thanks!!
- Fri May 18, 2018 9:42 am
- Forum: PATSTAT Product Line
- Topic: Only 30% person_address available?
- Replies: 2
- Views: 3129
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...
- Tue Apr 24, 2018 3:22 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT - ORACLE loading scripts
- Replies: 21
- Views: 42532
Re: PATSTAT - ORACLE loading scripts
Update: Added scripts for Patstat 2018 Spring Edition
- Tue Feb 20, 2018 9:56 am
- Forum: PATSTAT Product Line
- Topic: Import data from excel - PATSTAT 2017 Autumn
- Replies: 2
- Views: 3544
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...