When you use the %MDUCHGV macro (which is used for metadata identity synchronization), the following warning is generated:

This message occurs because of a change in PROC SQL reporting in SAS^® 9.3. The SQL procedure cannot determine the length of an expression result during the compilation phase of the step. The warning is produced when the expression result is greater than 200 bytes.

You can ignore this warning. The significant characters in the expression result will never be truncated.

The following expressions are used in the SQL procedure's INSERT INTO statements to populate the ERRORSDS data set within the %MDUCHGV macro.

If you want to omit the warning messages from the SAS log, or if your third-party job scheduler reports a failed job because of the warning, you should modify the %MDUCHGV macro by adding the NOWARN option to the PROC SQL step that generates the &ERRORSDS table and by resetting two return codes, as follows:

1. Copy the mduchgv.sas file into a different directory, as shown in the following examples:
   

   For UNIX Operating Environments:

   cp /usr/local/SASHome/SASFoundation/9.3/sasautos/mduchgv.sas /home/sas/mduchgv.sas

   For Microsoft Windows Operating Environments:

   copy "C:\Program Files\SASHome\SASFoundation\9.3\core\sasmacro\mduchgv.sas" "C:\Users\sas\Documents\My SAS Files\9.3\mduchgv.sas"
2. In the copied mduchgv.sas file, locate the PROC SQL step that begins with the following lines:
   
   proc sql noprint; /* Build the empty ERRORSDS data set. */ create table &errorsds ( errcode integer,
3. Add a %LET statement and the NOWARN option, as shown below:
   
   %let SYSCC_49002=&SYSCC; proc sql noprint nowarn; /* Build the empty ERRORSDS data set. */ create table &errorsds ( errcode integer, . . .additional lines. . . quit;
4. Add the following statements to conditionally reset SYSERR and SYSCC immediately after execution of the QUIT statement shown above:
   %if &SYSCC_49002=0 %then %do; %if &syscc=4 %then %do; %put RESETTING SYSCC and SYSERR; data _null_; run; %let syscc=0; %end; %end;
5. Modify your synchronization program to reference the saved copy of mduchgv.sas rather than the SAS autocall macro. Do this by adding the following %INCLUDE macro to your code before the macro call. Note: It is best practice to add the %INCLUDE statement near the top of the program to make the statement more visible.
   
   /* Use the edited version of the %MDUCHGV macro */ /* to prevent PROC SQL truncation warnings, per */ /* SAS Note 49002. */ %include '/home/sas/mduchgv.sas';

Operating System and Release Information