Creating WhoDrug Dictionary with Version December 2005

[David Main]

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?

[Greg Wagner]

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,
Greg

[David Main]

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

[Greg Wagner]

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.