 |
Find Drug Sales Data by Class in Pharmaceutical Company Files?
TOPIC: Pharmaceutical company reports on Dialog provide key sales data. IMS Company Profiles (Files 449/984*) from IMS Health, and ESPICOM Pharmaceutical and Medical Company Profiles (File 510), are examples.
IMS Company Profiles examines annually the internal make-up of key pharmaceutical companies worldwide, including generic, biotechnology and drug-delivery companies. Each profile analyzes the critical components of a pharmaceutical company, providing a clear assessment of the relative strengths and weaknesses of a company's business strategy. A search for a company yields one profile comprised of several records, one or more for each section. Sections are identified in the SE= field, e.g., SE=FINANCIAL DATA: THERAPY CLASS.
ESPICOM Pharmaceutical and Medical Company Profiles contains highly detailed, full-text analyses of the world’s leading pharmaceutical companies. Each company profile is compiled into a report. Each record is a section or page from a report. Typical applications for File 510 include: tracking product introductions, following new technologies, obtaining annual sales figures by region, monitoring product introductions, watching R&D and development cycles, and monitoring approvals and clearances.
In this application we'll conduct the search in IMS Company Profiles. A search strategy for the other database is also shown below.
*File numbers with asterisks indicate subscriber access only.
COMMAND SUMMARY
To search IMS Company Profiles (File 449), use the following search strategy:
BEGIN 449
EXPAND MT=GLAXO (Company name in the Main title (MT=) of a report)
SELECT “E” REFERENCE NUMBER
RANK SE CONT (RANK Section Heading, with Continuous Display)
Select the section relating to sales and
ENTER RANK ITEM NUMBER
EXIT
YES
EXS
SELECT S1 AND S2
TYPE S3/9/1
To search ESPICOM, use the following search strategy:
BEGIN 510
EXPAND MT=PFIZER (Company name in the Main title (MT=) of a report)
SELECT E4
REPORT S1/TITLES
Follow the menu
Note: the REPORT TITLES command allows you to view the sections and tables of contents of multi-page reports and choose just the pages you wish to display.
HOW TO...
1. BEGIN File 449 to search IMS Company Profiles.
|
?B 449
File 449:IMS Company Profiles 1992-2010/Jun
(c) 2010 IMS Health & Affiliates
Set Items Description
--- ----- ----------- |
| 2. EXPAND on the company name on the Main Title (MT=) field. |
? E MT=GLAXO
Ref Items Index-term
E1 44 MT=GENZYME
E2 37 MT=GILEAD SCIENCES
E3 0 *MT=GLAXO
E4 54 MT=GLAXOSMITHKLINE
E5 35 MT=GRUENENTHAL
E6 33 MT=HUMAN GENOME SCIENCES
E7 38 MT=IPSEN
E8 34 MT=ISIS
E9 53 MT=JOHNSON & JOHNSON
E10 37 MT=KING
E11 41 MT=KOWA
E12 49 MT=KYOWA HAKKO KIRIN
|
| 3. SELECT the appropriate "E" reference number to create Set 1. |
? S E4
S1 54 MT='GLAXOSMITHKLINE' |
| 4. RANK the Section Name (SE) field. CONT provides a continuous display of RANKed terms. Enter ALL to view all sections of the company profile. |
? RANK SE CONT
Started processing RANK
Completed Ranking 54 records
Press ENTER to view the TOP 50 terms
or enter a number N to view the top N terms
or >N to view terms with more than N items
or enter ALL to view all terms
? ALL
Enter title for continuous output or press ENTER for current title option
? GLAXOSMITHKLINE COMPANY PROFILE
Adding title to results...
GLAXOSMITHKLINE COMPANY PROFILE
-------------------------------
RANK: S1/1-54 Field: SE= File(s): 449
(Rank fields found in 54 records -- 51 unique terms)
RANK No. Items Term
-------- ----- ----
1 2 CORPORATE STRUCTURE
2 2 FINANCIAL DATA : KEY FIGURES
3 2 STRATEGY STATEMENT : FUTURE PROSPECTS
4 1 EMPLOYEE DATA
5 1 FINANCIAL DATA : ANALYSTS FORECASTS
6 1 FINANCIAL DATA : BUSINESS SECTORS
7 1 FINANCIAL DATA : GEOGRAPHY
8 1 FINANCIAL DATA : THERAPY CLASS
9 1 FINANCIAL REVIEW
10 1 FINANCIAL REVIEW : ANALYST COMMENT
11 1 LICENSING/CO-MARKETING AGREEMENTS : GENERAL RE
12 1 LICENSING/CO-MARKETING AGREEMENTS : MARKETED P
13 1 LICENSING/CO-MARKETING AGREEMENTS : R&D PIPELI
14 1 MAJOR EVENTS : MERGERS & ACQUISITIONS
15 1 MAJOR EVENTS : OTHER MAJOR EVENTS
16 1 PRODUCT PORTFOLIO : ALIMENTARY TRACT AND METAB
17 1 PRODUCT PORTFOLIO : ANTINEOPLASTICS/IMMUNOMODU
18 1 PRODUCT PORTFOLIO : BLOOD AND BLOOD-FORMING OR
19 1 PRODUCT PORTFOLIO : CARDIOVASCULAR SYSTEM AGEN
20 1 PRODUCT PORTFOLIO : CENTRAL NERVOUS SYSTEM AGE
21 1 PRODUCT PORTFOLIO : DERMATOLOGICAL AGENTS
22 1 PRODUCT PORTFOLIO : GENITOURINARY SYSTEM/SEX H
23 1 PRODUCT PORTFOLIO : INTRODUCTION
24 1 PRODUCT PORTFOLIO : MUSCULOSKELETAL SYSTEM AGE
25 1 PRODUCT PORTFOLIO : OTC PRODUCTS
26 1 PRODUCT PORTFOLIO : PARASITICIDAL AGENTS
27 1 PRODUCT PORTFOLIO : RESPIRATORY SYSTEM AGENTS
28 1 PRODUCT PORTFOLIO : SYSTEMIC ANTI-INFECTIVE AG
29 1 PRODUCT PORTFOLIO TABLE : PRODUCTS FACING PATE
30 1 R&D PIPELINE TABLE
31 1 R&D PROFILE : ALIMENTARY TRACT AND METABOLISM
32 1 R&D PROFILE : ANTINEOPLASTICS/IMMUNOMODULATING
33 1 R&D PROFILE : BLOOD AND BLOOD-FORMING ORGAN AG
34 1 R&D PROFILE : CARDIOVASCULAR SYSTEM AGENTS
35 1 R&D PROFILE : CENTRAL NERVOUS SYSTEM AGENTS
36 1 R&D PROFILE : DERMATOLOGICAL AGENTS
37 1 R&D PROFILE : DISCONTINUED COMPOUNDS
38 1 R&D PROFILE : GENITOURINARY SYSTEM/SEX HORMONE
39 1 R&D PROFILE : INTRODUCTION
40 1 R&D PROFILE : MUSCULOSKELETAL SYSTEM AGENTS
41 1 R&D PROFILE : PARASITICIDAL AGENTS
42 1 R&D PROFILE : RESPIRATORY SYSTEM AGENTS
43 1 R&D PROFILE : SYSTEMIC ANTI-INFECTIVE AGENTS
44 1 STRATEGY STATEMENT : BACKGROUND
45 1 STRATEGY STATEMENT : INTRODUCTION
46 1 STRATEGY STATEMENT : LICENSING
47 1 STRATEGY STATEMENT : M&A ACTIVITY
48 1 STRATEGY STATEMENT : PATENT ISSUES
49 1 STRATEGY STATEMENT : R&D
50 1 STRATEGY STATEMENT : REGIONAL STRATEGY
51 1 STRATEGY STATEMENT : THERAPEUTIC FOCUS
---end of results---
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.
|
| 5. Enter the RANK line-item number of the section(s) you wish to save. Dialog creates a temporary SearchSave that you will be able to EXECUTE upon exiting RANK. The top 8 RANK numbers and the RANK menu reappear. |
? 8
RANK numbers saved: 8
GLAXOSMITHKLINE COMPANY PROFILE
-------------------------------
RANK: S1/1-54 Field: SE= File(s): 449
(Rank fields found in 54 records -- 51 unique terms) Page 1 of 7
RANK No. Items Term
-------- ----- ----
1 2 CORPORATE STRUCTURE
2 2 FINANCIAL DATA : KEY FIGURES
3 2 STRATEGY STATEMENT : FUTURE PROSPECTS
4 1 EMPLOYEE DATA
5 1 FINANCIAL DATA : ANALYSTS FORECASTS
6 1 FINANCIAL DATA : BUSINESS SECTORS
7 1 FINANCIAL DATA : GEOGRAPHY
8 1 FINANCIAL DATA : THERAPY CLASS
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.
|
| 6. Enter EXIT to leave RANK. Respond Y (Yes) to confirm the exit. |
?. EXIT
RANK results will be erased; have you saved all the terms of interest?
(YES/NO)
? Y
Temp SearchSave "TD356" stored
Creating temporary SearchSave ... TD356
Enter EXS to execute the SearchSave
|
| 7. Enter EXS to EXECUTE the SearchSave. Combine Set 1 with the company name AND Set 2 with the selected section. The result will be one record: the financial data by therapeutic class for the specific company. |
? EXS
Executing TD356
S2 16 SE="FINANCIAL DATA : THERAPY CLASS"
? S S1 AND S2
54 S1
16 S2
S3 1 S1 AND S2 |
| 8. TYPE the selected record (section) in Format 9, the Full format. |
? T S3/9/1
3/9/1
DIALOG(R)File 449: IMS Company Profiles
(c) 2010 IMS Health & Affiliates. All rights reserved.
00048656 (THIS IS THE FULLTEXT)
GLAXOSMITHKLINE: FINANCIAL DATA : THERAPY CLASS
Main Title: GLAXOSMITHKLINE
Source: IMSworld Publications, Ltd Telephone: +44 20 7393 5000
April 13 2010
Language: English Record Type: Fulltext
Word Count: 271
Sales by Therapeutic Class/Leading Products for years ending December 31:
2009 2008 2007 2006 2005
Respiratoty 6,977 5,817 5,032 4,991 5,050
Antivirals 4,150 3,206 3,028 2,827 2,598
CNS 1,870 2,897 3,348 3,642 3,219
Vaccines 3,706 2,539 1,993 1,692 1,389
Cardiovas 2,298 1,847 1,554 1,636 1,331
cular &
Urogenital
Antibacte 1,592 1,429 1,323 1,363 1,513
rials
Metabolic 1,181 1,191 1,508 1,870 1,488
Oncology 629 496 477 1,069 1,016
& Emesis
Others 1,311 959 901 924 979
TOTAL 23,714 20,381 19,163 20,013 18,583
Source: GlaxoSmithKline
Unit: GBP millions
Copyright (c) 2007 IMSworld Publications, Ltd. All rights reserved.
Company: GLAXOSMITHKLINE |
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
 |
