Announcement

Collapse
No announcement yet.

Creating WhoDrug Dictionary with Version December 2005

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating WhoDrug Dictionary with Version December 2005

    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?
    Last edited by Ronni Rubenstein; 02-14-2008, 02:28 PM.

  • #2
    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
    Last edited by Ronni Rubenstein; 02-14-2008, 02:29 PM.

    Comment


    • #3
      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


      • #4
        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

        Working...
        X