DATA Step, Macro, Functions and more

Note of 'proc compare'

Accepted Solution Solved
Reply
Regular Contributor
Posts: 214
Accepted Solution

Note of 'proc compare'

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.

1.jpg

 

Thank you!


Accepted Solutions
Solution
3 weeks ago
Respected Advisor
Posts: 4,736

Re: Note of 'proc compare'

[ Edited ]
Posted in reply to DmytroYermak

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

View solution in original post


All Replies
Solution
3 weeks ago
Respected Advisor
Posts: 4,736

Re: Note of 'proc compare'

[ Edited ]
Posted in reply to DmytroYermak

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

Regular Contributor
Posts: 214

Re: Note of 'proc compare'

Thank you for the clarifications!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 82 views
  • 1 like
  • 2 in conversation