Code added to WEBA_SET_REFERRER_TYPE_CD will ensure there are no duplicates in the DOMAIN_DIM table during a migration from SAS® Web Analytics 5.3.1 to 5.3.3. The hot fix associated with Problem Note 40247 modifies the ucmacros\weba_set_referrer_type_cd.sas macro to remove the duplicates.

As an alternative to applying the hot fix, this macro can be modified manually. Add the following code to the ucmacros\weba_set_referrer_type_cd.sas macro:

   /* Due to MD5 5.3.1/5.3.3 conversion issues, it is possible in some cases */
   /* for duplicate natural keys to be created.  They must be eliminated,    */
   /* or errors will occur on the format creation.                           */

   proc sort data=&all_domains(rename=domain_nm=start keep=domain_nm)
             out=work.dedup nodupkeys;
    by start;
   run;

This code should be added immediately before the following statements:

   data work.cntlin;
        retain fmtname '$REFERRER_TYPE_CD_FMT';
        set work.dedup  end=end;
        label='I'; /* Internal */
        output;
        if end then
         do;
          hlo='O';
          start=' ';
          label='E'; /* External */
          output;
         end;
     run;

Operating System and Release Information

A fix for this issue for SAS Web Analytics 5.3_M3 is available at: