topic Re: Note of 'proc compare' in SAS Programming

Note of 'proc compare'

DmytroYermak — Sat, 23 Jun 2018 07:42:10 GMT

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!

Re: Note of 'proc compare'

Patrick — Sat, 23 Jun 2018 08:27:04 GMT

@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.

Re: Note of 'proc compare'

DmytroYermak — Sat, 23 Jun 2018 08:30:01 GMT

Thank you for the clarifications!