topic Re: Proc Compare Ndif Bug in SAS Programming https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483210#M125292 <P>I agree but also think that PROC COMPARE output could do with other improvements including proper ODS support. I'm happy to support / raise a SASware ballot suggestion if you wish.&nbsp;&nbsp;</P> Wed, 01 Aug 2018 21:54:02 GMT SASKiwi 2018-08-01T21:54:02Z Proc Compare Ndif Bug https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483176#M125275 <P>My team uses SAS &nbsp;9.4 (TS1M3) on Linux 2.6.32-754.el6.x86_64 (LIN X64) platform.&nbsp; Proc Compare has been a part of our production data validation each month.&nbsp; We use counts of differences as shown in Proc Compare's (<FONT face="courier new,courier">proc compare base=work.prior compare=work.current listequalvar listvar novalues</FONT>)&nbsp;output in the Ndif column:</P><P>&nbsp;</P><P><FONT face="courier new,courier" size="2">Variables with Unequal Values</FONT></P><P><FONT face="courier new,courier" size="2">Variable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp; Len&nbsp; Ndif&nbsp;&nbsp; MaxDif&nbsp; MissDif</FONT></P><P><FONT face="courier new,courier" size="2">acquired_dt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 4750&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</FONT><BR /><FONT face="courier new,courier" size="2">bkr_code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 2&nbsp; 7495&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7364</FONT><BR /><FONT face="courier new,courier" size="2">bkr_status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 1&nbsp; 7576&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7318</FONT><BR /><FONT face="courier new,courier" size="2">orig_dt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 911&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">clnt_inv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 6 65810&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">corpadv_r&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM&nbsp;&nbsp;&nbsp;&nbsp; 8 36885&nbsp;&nbsp; 117431&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">corpadv_r3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM&nbsp;&nbsp;&nbsp;&nbsp; <FONT color="#ff0000">8197427</FONT>&nbsp; 2151214&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">corr_data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 6 63001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 63001</FONT><BR /><FONT face="courier new,courier" size="2">distrib_ty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 1&nbsp; 1272&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">esc_doc_ty&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 37&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT><BR /><FONT face="courier new,courier" size="2">escr_bal&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NUM&nbsp;&nbsp;&nbsp;&nbsp; <FONT color="#ff0000">86.37E6</FONT>&nbsp;&nbsp; 229448&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</FONT></P><P><FONT face="courier new,courier" size="2">...</FONT></P><P>&nbsp;</P><P>Note however that there is no space or delimiter between "Len" and "Ndif".&nbsp; My team's SAS code to parse this produced incorrect values today since it couldn't distinguish between the "8" for Len, and the remaining count (Ndif).&nbsp; Yes, there are several ways to work around this, but the fact is, it is a bug.&nbsp; SAS should fix it.&nbsp; They should have fixed it long ago.</P> Wed, 01 Aug 2018 19:31:04 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483176#M125275 DougZ 2018-08-01T19:31:04Z Re: Proc Compare Ndif Bug https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483210#M125292 <P>I agree but also think that PROC COMPARE output could do with other improvements including proper ODS support. I'm happy to support / raise a SASware ballot suggestion if you wish.&nbsp;&nbsp;</P> Wed, 01 Aug 2018 21:54:02 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483210#M125292 SASKiwi 2018-08-01T21:54:02Z Re: Proc Compare Ndif Bug https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483214#M125294 That would be great (SAS ballot)!<BR /> Wed, 01 Aug 2018 22:10:02 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Ndif-Bug/m-p/483214#M125294 DougZ 2018-08-01T22:10:02Z