 |

Find Information on Drug Sales by Class?
TOPIC: Dialog contains a wealth of sources for finding sales information on pharmaceutical products. These sources include business trade literature, company reports, country reports, analysts’ reports, and market research reports. Many of these sources contain tabular data.
In this example we will look at strategies for finding sales information regarding pharmaceutical sales by drug class. Business & Industry (File 9) provides excellent indexing to help you quickly access facts, figures and key events in trade magazines, newsletters, business press, regional newspapers and international business dailies that focus on specific therapeutic areas.
This example shows a simple query on a therapeutic term in the Title field (/TI) and the use of the Dialog RANK command to pinpoint appropriate Product Code numbers (PC=) to use in the search. Additional databases where a similar strategy works include Gale Group PROMT® (File 16), Gale Group Trade & Industry Database (File 148) and TableBase (File 93).
COMMAND SUMMARY
BEGIN 9 CURRENT5
SELECT ANTIBIOTIC?/TI
RANK PN
VIEW 1/PN/1 and follow the RANK menu
S PC=NNNNNN AND SALES/DE
TYPE S2/8/1-3
TYPE S2/7/1
HOW TO...

1. BEGIN File 9 to search Business & Industry. Use the CURRENT5 feature to search only those records added to the database this calendar year and the five previous years.
2. SELECT a therapeutic term on the Title (/TI) field. |

?B9 CURRENT5
File 9:Business & Industry(R) Jul/1994-2007/Dec 06
(c) 2007 The Gale Group
>>>CURRENT5 started
Set Items Description
--- ----- -----------
?S ANTIBIOTIC?/TI
S1 321 ANTIBIOTIC?/TI |

3. RANK the Product Name (PN) field to find the Product Name and associated Product Code (PC=). Use of product indexing can result in a more focused search. Results of RANK show the product names in order by frequency of occurrence.
4. VIEW the Product Name (PN) for the appropriate RANKed item. VIEW functions in the same way as the TYPE command. Formats are priced as with TYPE.
Note the Product Code is alongside the product name. Notice that the RANK list reappears with the top 8 terms. Follow the menu prompt below the list for the next step, which is to EXIT RANK.
5. EXIT RANK.
6. Enter Yes (Y) to confirm and complete the exit from RANK. |

?.RANK PN
Started processing RANK
Processing 100 of 321 records
Processing 200 of 321 records
Processing 300 of 321 records
Completed Ranking 321 records
DIALOG RANK Results
--------------------
RANK: S1/1-321 Field: PN= File(s): 9
(Rank fields found in 306 records--86 unique terms) Page 1 of 11
RANK No. Items Term
-------- ----- ----
1 180 ANTIBIOTICS AND SULFONAMIDES, SYSTEMIC AND SYS
2 99 PHARMACEUTICAL PREPARATIONS
3 22 VETERINARY PHARMACEUTICAL PREPARATIONS
4 9 CHEMICALS AND ALLIED PRODUCTS
5 9 MEAT PRODUCTS
6 9 POULTRY AND EGG PROCESSING
7 8 DERMATOLOGICALS, EXCEPT SUNSCREEN AND SUNBURN
8 7 PREPARED FEEDS NEC
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.
?.VIEW 1/PN/1
--RANK 1 ITEM 1 --
Product Names:
Poultry and eggs (025000); Poultry farms (025902); Food and
kindred products (200000); Poultry and egg processing (201500);
Gummed paper and tape (267229); Antibiotics and sulfonamides,
systemic and systemic antifungals (283415)
DIALOG RANK Results
--------------------
RANK: S1/1-321 Field: PN= File(s): 9
(Rank fields found in 306 records--86 unique terms) Page 1 of 11
RANK No. Items Term
-------- ----- ----
1 180 ANTIBIOTICS AND SULFONAMIDES, SYSTEMIC AND SYS
2 99 PHARMACEUTICAL PREPARATIONS
3 22 VETERINARY PHARMACEUTICAL PREPARATIONS
4 9 CHEMICALS AND ALLIED PRODUCTS
5 9 MEAT PRODUCTS
6 9 POULTRY AND EGG PROCESSING
7 8 DERMATOLOGICALS, EXCEPT SUNSCREEN AND SUNBURN
8 7 PREPARED FEEDS NEC
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
Exiting... (no terms were saved) |

7. Search the Product Code (PC=) and the Descriptor “sales” to find articles indexed to those terms.
Note: It is often a good idea to EXPAND the Product Code (e.g., EXPAND PC=283415) and select the appropriate “E” Reference numbers. Then combine with sales/de. |

?S PC=283415 AND SALES/DE
720 PC=283415 (ANTIBIOTICS AND SULFONAMIDES, SYSTEMI
48907 SALES/DE
S2 67 PC=283415 AND SALES/DE |

8. TYPE a few records in Format 8 to see title, descriptors and publication years.
To select the appropriate record number, look at the range of records in the TYPE command (e.g., 2/8/2).
Note: Some records have been omitted from this display. |

?T S2/8/1-5
2/8/1
DIALOG(R)File 9: Business & Industry(R)
(c) 2007 The Gale Group. All rights reserved.
04173971 Supplier Number: 159344039 (USE FORMAT 7 OR 9 FOR
FULLTEXT)
Antibiotics, painkillers sales at all time high.
February 14, 2007
Word Count: 430
Industry Names: Pharmaceutical
Product Names: Pharmaceutical preparations (283400);
Antibiotics and sulfonamides, systemic and systemic
antifungals (283415)
Concept Terms: All market information; Consumption; Sales
2/8/2
DIALOG(R)File 9: Business & Industry(R)
(c) 2007 The Gale Group. All rights reserved.
03054496 Supplier Number: 102770222 (USE FORMAT 7 OR 9 FOR
FULLTEXT)
Anti-fungal benefits from foot-forward fashion.(Category
Report: OTC).
May 19, 2003
Word Count: 512
Special Features: Table
Industry Names: Pharmaceutical
Product Names: Antibiotics and sulfonamides, systemic and
systemic antifungals (283415)
Concept Terms: All market information; Sales
Geographic Names: North America (NOAX); United States (USA) |

9. TYPE selected record(s) in Format 7, which gives the bibliographic citation and text.
Note: Part of this record is omitted from the display. |

?T S2/7/1
2/7/1
DIALOG(R)File 9: Business & Industry(R)
(c) 2007 The Gale Group. All rights reserved.
04173971 Supplier Number: 159344039 (THIS IS THE FULLTEXT)
Antibiotics, painkillers sales at all time high.
Knight-Ridder Tribune Business News , p NA
February 14, 2007
Word Count: 430
TEXT:
Byline: Rupali Mukherjee
Feb. 14--NEW DELHI -- Rise in viral/bacterial infections and a
massive resurgence of epidemics last year led to a huge spurt
in the acute segment (antibiotics and pain killers), surpassing
even that of chronic/lifestyle therapy segment for the first
time in recent years.
Sales of medicines used to treat viral fevers and infective
diseases (systemic anti-infectives) grew by nearly 18 percent,
more than those categorized under digestive tract and
metabolism segment (diabetes and obesity) at 16.44 percent in
2006, according to the latest figures of ORG-IMS.
Anjan Sen, director-pharma marketing, Pfizer says: "Compared to
the last four years, 2006 has seen a change in trends in the
area of acute and chronic therapies. The acute segment has
had a growth spurt whereas chronic therapy has remained the
same. A probable reason for this could be the spread of
chikunguniya that led to an increase in demand for
anti-infectives, pain-killers and anti-pyretics.
Secondly, market growth in 2006 has been driven by
rural segment as more and more firms have decided
to penetrate these markets".
Says Sandeep Gupta CMD, Eli Lilly India, "The
growth in antibiotics and painkillers seem to be
primarily driven by epidemics/ scares liek as
chikungunya, dengue, bird flu (antibiotic prophylaxis)
and increase in water borne diseases. There was
migration towards the more expensive anti-biotics
-- driven both by the rise in puchasing power,
coupled with heightened awareness about the epidemics".
(....)
Copyright (c) 2007, The Times of India
Distributed by McClatchy-Tribune Business News.
For reprints, email tmsreprints@permissionsgroup.com,
call 800-374-7985 or 847-635-6550, send a fax to
847-635-6968, or write to The Permissions Group Inc.,
1247 Milwaukee Ave., Suite 303, Glenview, IL
60025, USA.
TICKER SYMBOL(S): LLY, RBXZF, RANB, PFE |
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

|

You are viewing the

Click below to view the
 |