SAS DI : LookUp Transformation Log

[JJP1]

Hi Team,

Would you please help on i ran the lookup transformation in SAS DI.the job log is showing  below note.

would you please suggest on below note in log .... what does it mean please

Query over :
NOTE: There were 39432 observations read from the data set test
Source records with errors: 27360
Total lookup exceptions: 27360

Why are these suggesting source record errors?please help

[Patrick · Accepted solution]

@JJP1 

Look into the generated SAS code and things will become clear.

These are the number of rows in your source table where there hasn't been a matching record in the lookup table.

 set <source table> end = eof;
.....
/* Examine success of lookups  */
   if ( rc0=0 ) then
   do;
      /* Write row to target  */
      output ...;
      return;
   end;
   else
   do;
      error_total + 1;
      ....
   end; /* One or more lookups failed */

   if (eof = 1) then
   do;
      put "Source records with errors: " error_total ;
      put "Total lookup exceptions: " exception_total ;
   end; 

If you also define an error and exception table then that's where such things get captured. 

[JJP1]

Thanks @Patrick & @Kurt_Bremser for guiding me

[Kurt_Bremser]

I take it that these are the observations for which no lookup value was found.