Dialog
Dialog Support   >   "How Do I...?" Series   >   Patents
Dialog "How Do I...?" - Patents

Find Top Companies and Their Products Using Business Databases?

TOPIC: In this example, you want to find the top pharmaceutical companies and their leading drugs. Indexing helps you identify the drugs and get a listing. Use Gale Group PROMT ® (File 16) to take advantage of the indexing. You can also try Business & Industry™ (File 9), covering a wide range of industries and markets.

 

COMMAND SUMMARY

BEGIN 16
SELECT PN=DRUGS & PHARMACEUTICALS
SELECT TOP OR LEADING
SELECT RANKING?/DE
SELECT S1 AND S2 AND S3
SELECT S4/2005:2006
TYPE S5/6/ALL
TYPE S5/9/1


HOW TO...



1. BEGIN 9,16 business databases to take advantage of the indexing.

 

 

 

2. Use the indexing for product name (PN=) and the descriptor field (/DE) for a ranking to refine the search strategy.

 

 

3. Combine the sets.

 

 

4. Limit the search to the year 2005 and 2006 (/2005:2006).


?b 16
  File  16:Gale Group PROMT(R) 1990-2006/May 16
   (c) 2006 The Gale Group
Set  Items  Description
---  -----  -----------
?S PN=DRUGS & PHARMACEUTICALS
     S1   85234  PN=DRUGS & PHARMACEUTICALS

?S TOP OR LEADING 1082911  TOP 1630902  LEADING S2 2418605  TOP OR LEADING
?S RANKING?/DE S3    6337  RANKING?/DE
?S S1 AND S2 AND S3 85234  S1 2418605  S2 6337  S3 S4      13  S1 AND S2 AND S3
?S S4/2005:2006 13  S4 1633459  PY=2005 : PY=2006 S5       8  S4/2005:2006


5. TYPE all the records using Format 6 to see which is most relevant.

 

 


?T S5/6/ALL 
  5/6/1   (Item 1 from file: 16)  
12897155 Supplier Number: 139345291 (USE FORMAT 7 FOR FULLTEXT)
Journals gather momentum: medical/surgical journals continued 
to show positive signs in 2004, with an impressive double-digit 
increase in advertising revenues. Eugene M. May charts the 
biggest advertisers and the most heavily advertised products 
and therapeutic classes.(PERQ/HCI  
MEDICAL/SURGICAL JOURNAL AD REVIEW 2004 FULL YEAR)  
April, 2005
Word Count:   1911 
  5/6/2   (Item 2 from file: 16)  
12781481 Supplier Number: 139787991 (USE FORMAT 7 FOR FULLTEXT)
The Growing Demands for Existing Biologics Production are 
Reflected in Biopharmaceutical Sales Figures: The Top 15 
Products in 2004 Posted
Revenues of $38 Billion.   Dec 15, 2005 Word Count:   535
  5/6/3   (Item 3 from file: 16)  
12775962 Supplier Number: 139577090 (USE FORMAT 7 FOR FULLTEXT)
2005's top 10.(drugs sales report )(Brief Article)  
Dec 8, 2005
Word Count:   243 
  5/6/4   (Item 4 from file: 16)  
12507292 Supplier Number: 135665216 (USE FORMAT 7 FOR FULLTEXT)
 Onslaught of industry issues besieges brands.(pharmaceutical 
industry)  
August 22, 2005
Word Count:   1004 
  5/6/5   (Item 5 from file: 16)  
12126556 Supplier Number: 132891361  (USE FORMAT 7 FOR FULLTEXT)
Top pharma firms failing to deliver major new products, says 
Wood Mackenzie.(markets)  
May 30, 2005
Word Count:   319 
 5/6/6   (Item 6 from file: 16)  
12125825 Supplier Number: 132676315 (USE FORMAT 7 FOR FULLTEXT)
Top 50 H&BA brands.(sales survey)(Illustration)  
May 23, 2005
Word Count:   295 
  5/6/7   (Item 7 from file: 16)  
11909652 Supplier Number: 130350318 (USE FORMAT 7 FOR FULLTEXT)
Top 200 brand-name drugs by retail dollars in 2004.
(Illustration)
  Feb 21, 2005 Word Count:   296
  5/6/8   (Item 8 from file: 16)  
11817111 Supplier Number: 128207801 (USE FORMAT 7 FOR FULLTEXT)
Future blockbusters: acomplia is the most anticipated among 10 
products projected to win U.S. approval in 2005 and generate 
peak sales of at least $1 billion.(Fifth Annual Report)  
Jan, 2005
Word Count:   6928 



6. TYPE the seventh record using Format 9 to see the complete record.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Note: Part of the record is omitted from this display.


?t s5/9/7
  5/9/7  
DIALOG(R)File  16:Gale Group PROMT(R)
   (c) 2006 The Gale Group. All rts. reserv.
11909652   Supplier Number: 130350318 (THIS IS THE FULLTEXT) Top 200 brand-name drugs by retail dollars in 2004.
(Illustration)
  Drug Topics, v149, n4, p18 Feb 21, 2005 ISSN:  ISSN: 0012-6616 Language:  English    Record Type:  Fulltext Article Type: Illustration Document Type: Magazine/Journal; Trade Word Count:   296
TEXT:
TOP   200 BRAND-NAME DRUGS BY RETAIL DOLLARS IN 2004     
     What goes up must come down. That line, however, 
doesn't seem to hold true for many of the drugs in the 
exalted ranks of the top 10, as the table below demonstrates. 
The top 200 drugs by units (prescriptions)will be published 
in our March 7 issue.

                               Total retail   % change  dollars      from one
Rank   Product                 (add 000)     year ago
  1    Lipitor                  $5,959,955      10.9%
  2    Prevacid                  3,197,890      -4.8
  3    Zocor                     3,150,892       2.8
  4    Nexium                    2,963,518      19.0
  5    Zoloft                    2,622,801       6.6
  6    Advair Diskus             2,323,170      22.7
  7    Effexor XR                2,281,014      19.4
  8    Plavix                    2,169,479      30.4
  9    Celebrex                  2,114,734       6.0
 10    Neurontin                 2,000,077       3.1
 11    Protonix                  1,910,067      26.8
 12    Norvasc                   1,883,014       9.8
 13    Zyprexa                   1,881,354      -8.8 

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 #: 54129; Last modified: 22 Oct 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