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!
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
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
Thank you for the clarifications!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.