Dialog
Dialog Support   >   "How Do I...?" Series   >   Pharmaceuticals & Health Devices
Dialog "How Do I...?" - Pharmaceuticals & Health Devices

Create a List of Patent Holders in European Countries for a Category of Drug Patents Due to Expire in a Particular Year?

TOPIC: In this example, you want to create a list of patent assignees in European countries that have patents for anti-depressant drugs due to expire in the later half of 2005. IMS Patent Focus (File 447) monitors patent expiration dates worldwide and includes evaluated patent data from 57 countries with priority details (country, number, date) and patent application numbers by country. The therapeutic class code can be used to create a list of drug patents.

The RANK command lets you perform trend or statistical analysis on an existing search set by extracting terms from the specified field(s) in a set of records and lists them in ranked order, with the most highly posted term appearing first.

 

COMMAND SUMMARY

BEGIN 447
SELECT TC=N6A?
SELECT ED=20050601:20051231
SELECT S1 AND S2
SELECT S3 AND PC=(FR or ES or IT or EP)
RANK PA
and follow the RANK menu
EXS
SELECT S4 AND S5
TYPE S6/9/1

Note: If you do not know the therapeutic class code, SELECT the therapeutic class (e.g., antidepressant?) and TYPE the resulting set using Format 6 to see the class code.


HOW TO...



1. BEGIN 447 to search a file that contains drug patent details and expiration dates worldwide.

2. SELECT the therapeutic class code for anti-depressants. Use truncation (?) to retrieve all narrower classes.

3. Use ED=YYYYMMDD for the expiration date range from June 1, 2005 to Dec. 31, 2005.

4. Use PC= to limit the search with specific patent country codes. Note that the country code EP includes the states designated in a regional EP patent, but not applications filed in individual European countries.


?b 447

File 447:IMS Patent Focus 2006/Jul
       (c) 2006 IMS Health & Affiliates
 
      Set  Items  Description
      ---  -----  -----------
?SELECT TC=N6A?
      S1    4139  TC=N6A?

?SELECT ED=20050601:20051231
      S2    2380  ED=20050601:20051231

?S S1 AND S2
            4139  S1
            2380  S2
      S3     102  S1 AND S2

?SELECT S3 AND PC=(FR OR ES OR IT OR EP)
             102  S3
            1308  PC=FR
            1686  PC=ES
             641  PC=IT
           35518  PC=EP
      S4      55  S3 AND PC=(FR OR ES OR IT OR EP)



5.
Use the RANK command to obtain a list of patent assignees (PA) with the one with the most hits at the top of the list.

 

 

 

 

 

 

 

 

Select the company you want to include in your search, in this example, number 3.

 

 

 

 

 

 

 

 

 

 

 

Exit the Rank menu to continue searching.

You will be prompted to see if you have saved the terms you want.


?RANK PA
Started processing RANK
Completed Ranking 55 records
DIALOG RANK Results
--------------------
RANK: S4/1-55   Field: PA=  File(s): 447
(Rank fields found in 55 records -- 9 unique terms) Page 1 of 2
RANK No.  Items  Term
--------  -----  ----
    1       12   LUNDBECK
    2       11   THOMAE
   
3       11   WELLCOME
    4       10   FERROSAN
    5        4   DUPHAR
    6        3   TROPON
    7        2   FARMITALIA CARLO ERBA
    8        1   AMERICAN HOME PRODUCTS
P =  next page      Pn = Jump to page n
P- = previous page  M =  More Options     Exit = Leave RANK
To view records from RANK, enter VIEW followed by RANK number,
format, and item(s) to display, e.g., VIEW 2/9/ALL.
Enter desired option(s) or enter RANK number(s) to save terms.
?3

RANK numbers saved: 3
DIALOG RANK Results
--------------------
RANK: S4/1-55   Field: PA=  File(s): 447
(Rank fields found in 55 records -- 9 unique terms) Page 1 of 2
RANK No.  Items  Term
--------  -----  ----
    1       12   LUNDBECK
    2       11   THOMAE
    3       11   WELLCOME
    4       10   FERROSAN
    5        4   DUPHAR
    6        3   TROPON
    7        2   FARMITALIA CARLO ERBA
    8        1   AMERICAN HOME PRODUCTS
P =  next page      Pn = Jump to page n
P- = previous page  M =  More Options     Exit = Leave RANK
To view records from RANK, enter VIEW followed by RANK number,
format, and item(s) to display, e.g., VIEW 2/9/ALL.
Enter desired option(s) or enter RANK number(s) to save terms.
?exit

RANK results will be erased; have you saved all the terms of interest?
(YES/NO)
?Y



6. Execute (EXS) the Rank SearchSave. Note that Set 5 (S5) contains all patents for patent assignee Wellcome.

7. Combine S5 and the set (S4) limited by date, location and code for anti-depressants.


Temp SearchSave "TD357" stored
Creating temporary SearchSave ... TD357

Enter EXS to execute the SearchSave
?EXS
Executing TD357
      S5    3407  PA="WELLCOME"

?S S4 AND S5
              55  S4
            3407  S5
      S6      11  S4 AND S5

8. Note that FULL format in this database is Format 19, which includes a chemical structure.

 

You can order the complete patent from the Thomson Patent Store or find it in a fulltext patent database by entering the patent or application number.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The patent in Sweden expired in July 2005.

?T S6/9/1
 
  6/9/1  
DIALOG(R)File 447:IMS Patent Focus
(c) 2006 IMS Health & Affiliates. All rts. reserv.
 
00086641
 Drug Name:  bupropion; bupropion hydrochloride; bupropin; amfebutamone  
Patents International - February 28 2001 (20010228)
 
DRUG INFORMATION:
  CAS Registry Number:      34911-55-2, no stereo, bupropion
                            31677-93-7, no stereo, hydrochloride
                            34841-39-9, replaced by 34911-55-2
                            34841-36-6, replaced by 31677-93-7
                            93109-99-0, no stereo, fumarate (1:1)
                            93109-98-9, no stereo, maleate (1:1)
                            93110-04-4, no stereo, formate
                            93110-00-0, no stereo, citrate
                            93110-01-1, no stereo, mesilate
                            93110-03-3, no stereo, phosphate
                            93110-02-2, no stereo, triflate
                            144445-76-1, (-)
                            144445-75-0, (+)
  Brand Name:               WELLBUTRIN; ZYBAN
  Laboratory Code:          BW 323U
  Therapeutic Class Code:   N6A (Psychoanaleptics, Antidepressants)
                            N7B (Antismoking Products)
                            A8A (Anorectics)
                            N7X (All Other CNS Drugs)
  Clinical Indications:     depression
                            nicotine withdrawal
                            obesity
                            sexual dysfunction
 
PATENT INFORMATION:
  Patentee:              Wellcome (UK)
  Parent Company:        GlaxoSmithKline (UK)
  Patent Type:           Method of use
 
  Patent                 Patent      Patent    Expiration
  Country                Number      Date      Date
  ---------------------- ----------- --------- --------
  EP (Sweden EP)        EP 171227    19881102   20050724
 
  Priority               Priority    Priority
  Country                Number      Date
  ---------------------- ----------- ---------
  US (USA)                US 634451    19840725
PATENT SUMMARY:

The patent family listed here claims the use of bupropion in the
treatment of psychosexual dysfunction.


RELATED HOW DO I...? SOLUTIONS

 

 

NEED HELP?

Contact the Dialog Knowledge Center
Within North America 1 800 3 DIALOG (334 2564)
Outside North America 00 800 33 DIALOG (33 34 2564)
Web Form www.dialog.com/contacts/webform

Stock #: 54317; Last modified: 14 Sep 2011


You are viewing the
Dialog Classic Version

Click below to view the
DialogLink 5 Version
Dialog Home   |   About Dialog   |   Site Search
Copyright Notices   |   Terms of Use   |   Privacy Statement