I am using the MAKEWHOD.SAS program to create the WHO Drug Dictionary for the December 2005 version. The program uses the file B2 and expects files like BNA.DD. The December 2005 version in the B2 File BNA.txt. Should I change the program to remove the .dd suffix in the earliest infile statement? Or is there an updated program written for the Dec 2005 Dictionary?
Announcement
Collapse
No announcement yet.
Creating WhoDrug Dictionary with Version December 2005
Collapse
X
-
Creating WhoDrug Dictionary with Version December 2005
Last edited by Ronni Rubenstein; 02-14-2008, 02:28 PM.Tags: None
-
Dave,
Yes, you can either change the name of the files to have the proper extension or change the program to look for the text files.
Regards,
GregLast edited by Ronni Rubenstein; 02-14-2008, 02:29 PM.
-
Result of Who Drug Run
Hi Greg
I made the changes and ran the program. The log shows all is well until the last step. I received this in the log
1044 proc datasets library=out;
Directory
Libref OUT
Engine V9
Physical Name P:\Program Files\dicts\whodrug\whodrugDec2005
File Name P:\Program Files\dicts\whodrug\whodrugDec2005
Member
# Name Type File Size Last Modified
1 DRUG DATA 53347328 08Dec05:09:14:08
2 USERDATA DATA 33792 08Dec05:09:07:12
USERDATA INDEX 17408 08Dec05:09:07:12
1045 modify drug;
1046 index create medname;
NOTE: Simple index medname has been defined.
1047 index create &compfld;
NOTE: Simple index COMPRESS has been defined.
NOTE: MODIFY was successful for OUT.DRUG.DATA.
1048
1049 modify &userdsn;
1050 index create medname;
ERROR: An index named medname with the same definition already exists for file
OUT.USERDATA.DATA.
1051 index create &compfld;
1052
1053 quit;
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE DATASETS used (Total process time):
real time 13.38 seconds
cpu time 1.21 seconds
do I need to do anything with this error?
Thanks
Dave
Comment
-
This should be fine. It's just that the index already existed on the user table. Perhaps the user dictionary table, which was specified, already existed in that location? The index was created successfully on the main dictionary table.Last edited by Ronni Rubenstein; 02-14-2008, 02:30 PM.
Comment
Comment