 |

Find and Track Companies that are Working on Drugs for a Particular Type of Indication?
TOPIC: In this example, you will set up a Dialog Alert to monitor companies who are developing drugs for inflammatory indications. A Dialog Alert is a current awareness service that allows a search to run automatically whenever new records are added to the database(s).
Two databases useful for this search are IMS R&D Focus (File 445) and Pharmaprojects (File 128)*. IMS R&D Focus contains two types of records: R&D Focus (Drug Profile records) and R&D Drug News (Drug News records). Information provided includes: full synonyms, licensing status, patent summary, development history, commercial potential, company activity, scientific and commercial summaries and abstracts of significant scientific papers. Pharmaprojects reports on the progress of new pharmaceutical products, both new chemical and biotechnological entities, at all stages of development.
You will also use the RANK command in this search
to find companies that are in a particular therapeutic
class. The RANK command extracts terms from a
specified field in a set of records and lists
them in ranked order, with the most highly posted
term appearing first.
*(Subscriber access.)
COMMAND SUMMARY
BEGIN 445
SELECT PHASE OR CLINICALS OR IND OR PRE()REGISTRATION OR NDA
SELECT TC=L4A?
SELECT S2 AND PY=2004:2006
RANK CO
Follow the RANK menu
EXS
SELECT S1 AND S3 AND S4
TYPE S5/3/1-3
SAVE ALERT
Follow the Alert menu
HOW TO...

1. BEGIN File 445, IMS R&D Focus.
2. SELECT keywords to include any status a drug might be in.
3. SELECT the therapeutic class code for immuno-suppressive agents (L4A) and narrow the search to the most recent years.
Note that the therapeutic class code contains truncation to retrieve all narrower classes. |

?B 445
File 445:IMS R&D Focus 1991-2006/Aug W2
(c) 2006 IMS Health & Affiliates
Set Items Description
--- ----- -----------
?SELECT PHASE OR CLINICALS OR IND OR PRE()REGISTRATION OR NDA
37829 PHASE
438 CLINICALS
4004 IND
4027 PRE
3873 REGISTRATION
3335 PRE(W)REGISTRATION
3251 NDA
S1 40871 PHASE OR CLINICALS OR IND OR PRE()REGISTRATION OR NDA
?SELECT TC=L4A?
S2 3530 TC=L4A?
?SELECT S2 AND PY=2004:2006
3530 S2
29752 PY=2004 : PY=2006
S3 1428 S2 AND PY=2004:2006 |

4. RANK the company name (CO). Rank lets you extract the companies that are working most in this therapeutic class and ranks them with the company with the highest number of drugs listed first.
From the displayed list of companies, type the numbers of the ones that you want to track, in this example the top 5.
Exit the rank menu to continue searching.
Type YES if you have saved all terms of interest. |

?RANK CO
Started processing RANK
Processing 500 of 1428 records
Processing 1000 of 1428 records
Completed Ranking 1428 records
DIALOG RANK Results
--------------------
RANK: S3/1-1428 Field: CO= File(s): 445
(Rank fields found in 1428 records -- 441 unique terms) Page 1 of 56
RANK No. Items Term
-------- ----- ----
1 40 NOVARTIS
2 32 AMGEN
3 31 SERONO
4 26 BIOGEN IDEC
5 24 CELGENE
6 23 ROCHE
7 22 ASTELLAS
8 22 WYETH
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.
?1-5
RANK numbers saved: 1-5
DIALOG RANK Results
--------------------
RANK: S3/1-1428 Field: CO= File(s): 445
(Rank fields found in 1428 records -- 441 unique terms) Page 1 of 56
RANK No. Items Term
-------- ----- ----
1 40 NOVARTIS
2 32 AMGEN
3 31 SERONO
4 26 BIOGEN IDEC
5 24 CELGENE
6 23 ROCHE
7 22 ASTELLAS
8 22 WYETH
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 |

5. Execute (EXS) the SearchSave you created from the Rank menu with the top 5 companies.
6. Combine sets of company names, keywords, and therapeutic class limited by publication year. |

Temp SearchSave "TD494" stored
Creating temporary SearchSave ... TD494
Enter EXS to execute the SearchSave
?EXS
Executing TD494
S4 1584 CO="NOVARTIS"
S5 583 CO="AMGEN"
S6 272 CO="SERONO"
S7 161 CO="BIOGEN IDEC"
S8 175 CO="CELGENE"
S9 2758 S4:S8
?S S1 AND S3 AND S9
40871 S1
1428 S3
2758 S9
S10 104 S1 AND S3 AND S9 |
7. TYPE out a few records to check the relevance of your search before setting up the Alert.
Note the drug name, originator, therapeutic class code and development status. |
?T S10/3/1-2
10/3/1
DIALOG(R)File 445:IMS R&D Focus
(c) 2006 IMS Health & Affiliates. All rts. reserv.
02025059
R&D Focus - February 06, 2006 (20060206)
COMPANY INFORMATION:
Originator: Celgene; (USA); NA; NA; NA
DRUG INFORMATION:
Laboratory Code: CC 10015
Pharmacological Action: TNF modulator; immunosuppressant
Therapeutic Class Code: L4A (Immunosuppressive Agents)
Clinical Indications: inflammation
Molecular Code: 7189120000
CURRENT DEVELOPMENT STATUS:
Highest Phase: Preclinical (20)
10/3/2
DIALOG(R)File 445:IMS R&D Focus
(c) 2006 IMS Health & Affiliates. All rts. reserv.
02025058
R&D Focus - February 06, 2006 (20060206)
COMPANY INFORMATION:
Originator: Celgene; (USA); NA; NA; NA
DRUG INFORMATION:
Laboratory Code: CC 11006
Pharmacological Action: TNF modulator; immunosuppressant
Therapeutic Class Code: N7X (All Other CNS Drugs);D3A (Wound
Agents);L4A (Immunosuppressive Agents)
Clinical Indications: inflammation; pulmonary fibrosis; scleroderma; amyotrophic lateral sclerosis
Molecular Code: 7189110000
CURRENT DEVELOPMENT STATUS:
Highest Phase: Phase I (30) |
8. Type SAVE ALERT to begin setting up the Alert; then follow the Alert menu.
Select when you want the Alert to run--when the file is updated or on a schedule of your choosing.
Remove duplicates.
Review your Alert settings and SAVE them.
Enter a name for the Alert.
Enter a PRINT command. In this example, the Alerts will be sent to the e-mail address at the end of the Print statement.
SAVE the Alert. |
?SAVE ALERT
Do you want the Alert run based on a file's Alert Update schedul
or on a Custom schedule you set up? U=Update C=Custom Q=Quit H=Help
?U
If a file has multiple update frequencies, do you want to accept
the default or choose file by file? D=Default C=Choose
Q=Quit H=Help
?D
Do you want duplicates removed automatically? Y=Yes N=No H=Help
?Y
Do you want notification even if no documents are found?
Y=Yes N=No
?N
Your alert currently has these settings:
1. Databases: 445
2. Frequency: When database is updated
445(W)
3. Run at: When database is updated
4. Dedupe: Y
5. Notify: ONLY when new documents are found (Notify=OFF)
To make a change, enter a line number.
To save the Alert, enter S for Save. Q=Quit H=Help
?S
Enter 1 to 30 characters for a name. Q=Quit H=Help
?COMPANIES
Enter a PRINT statement for your Alert. Q=Quit H=Help
?PR S10/9/ALL ADDR BAJABEV
Enter the next PRINT command or enter S to SAVE.
Q=Quit H=Help
?S
Alert "COMPANIES" saved |
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
 |