Note of 'proc compare'

[DmytroYermak]

Hi all,

Could you please say what is the reason for the Note below. It seems to be a mistake of 'proc compare'. But I don't understand how to avoid it.

Thank you!

[Patrick · Accepted solution]

@DmytroYermak

It's only a NOTE.

There is nothing wrong with Proc Compare and you can easily replicate such a note with below code.

data test;
  format numvar 6.2;
  numvar=123456789.12;
run;

proc print data=test;
run;

The NOTE lets you know that the permanent format applied to the variable is insufficient to print the actual number so SAS needs to use a different format (BEST32.) instead.

NOTE: There were 1 observations read from the data set WORK.TEST.
NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format.

s 

[DmytroYermak]

Thank you for the clarifications!