Hi I am getting the below error message when i compare two dataset using proc compare. WARNING: The requested format could not be applied successfully because the Value Comparison Results report restricts the variable's column width to 9 and this format requires a larger minimum width. please help me to solve this. CODE: data a; b=4244; format a b is8601da.; run; data b; b=3213; format a b is8601da.; run; proc compare base=a comp=b maxprint=(30,20); run; PLs find the attached output.
Interesting. Looks like the format you used is too wide to fit in the PROC COMPARE output. I would have thought SAS would automatically change to use a best. format instead, but apparently it doesn't. Probably the easiest thing to do would just be to "un-format" the variable in your PROC COMPARE step.
proc compare .... ;
format a b; * Clear problematic formats. Can also use format _all_ ;
run;
That should allow the step to run.
Hi there, Thanks, but i would like to compare the data with formats applied. Is there anyother options (in PROC COMPARE) or method to compare the formatted datasets. Thanks
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.