topic Proc Compare Output Explanation in SAS Programming https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978534#M378619 <P>Good afternoon.</P> <P>&nbsp;</P> <P>I am new to proc compare and I wondered if anyone could point me in the direction of any explanations to what the output values mean? It seems to work for me but I wanted to be sure I totally understood what each value in the output means (Ex. XXXX, E, ....,, -35, etc.). All the explanations I can find reference understanding the proc print output, but I wanted to see mine like this in tabular style. I can read the documentation myself but can't seem to find any.</P> <P>&nbsp;</P> <TABLE width="1848"> <TBODY> <TR> <TD width="48">_TYPE_</TD> <TD width="38">VAR1</TD> <TD width="49">VAR2</TD> <TD width="63">VAR3</TD> <TD width="38">VAR4</TD> <TD width="38">VAR5</TD> <TD width="39">VAR6</TD> <TD width="38">VAR7</TD> <TD width="38">VAR8</TD> <TD width="38">VAR9</TD> <TD width="45">VAR10</TD> <TD width="45">VAR11</TD> <TD width="45">VAR12</TD> <TD width="45">VAR13</TD> <TD width="47">VAR14</TD> <TD width="45">VAR15</TD> <TD width="68">VAR16</TD> <TD width="75">VAR17</TD> <TD width="45">VAR18</TD> <TD width="324">VAR19</TD> <TD width="45">VAR20</TD> <TD width="45">VAR21</TD> <TD width="45">VAR22</TD> <TD width="79">VAR23</TD> <TD width="47">VAR24</TD> <TD width="45">VAR25</TD> <TD width="47">VAR26</TD> <TD width="45">VAR27</TD> <TD width="79">VAR28</TD> <TD width="59">VAR29</TD> <TD width="54">VAR30</TD> <TD width="47">VAR31</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>32054</TD> <TD>20030613</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-120023</TD> <TD>31516</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>32054</TD> <TD>20250415</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXXXXXXXXXXXXXXXXXXXXX..XXXXXXXXXXX.XXX</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-610</TD> <TD>54344</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>33821</TD> <TD>20250721</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>34250</TD> <TD>20250702</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>..XXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXX.....</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-202</TD> <TD>-1999</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-299</TD> <TD>48017</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>35838</TD> <TD>20240723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-10285</TD> <TD>-9590</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>39678</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>-35</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>1016</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>44757</TD> <TD>20250705</TD> <TD>E</TD> <TD>-1</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>-2</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>.....X....</TD> <TD>E</TD> <TD>-581</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>48518</TD> <TD>20250722</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>59462</TD> <TD>20250425</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>XXXXXXXXXXXXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-305</TD> <TD>5723</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>61460</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>70</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>40688</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>67105</TD> <TD>20250514</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>...............XXXXXXXXXXXXXXXXXXXXX....</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-299</TD> <TD>-12740</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-299</TD> <TD>-12740</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>85268</TD> <TD>20250813</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>155</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>-20250812</TD> <TD>XXXXXXX...</TD> <TD>X</TD> <TD>...............XXXX.XX.XXXXXXX..........</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-98</TD> <TD>63097</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>86947</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>200</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>.XXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>21765</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>88047</TD> <TD>20250604</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>XXXXXXXXX...............................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-93</TD> <TD>62136</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>92094</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>-42064</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>95910</TD> <TD>20250722</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96247</TD> <TD>20240813</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-10013</TD> <TD>58615</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96593</TD> <TD>20200114</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..................XXXX..............</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-9805</TD> <TD>-61513</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96593</TD> <TD>20210409</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..................XXXX..............</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-9805</TD> <TD>-61513</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>101163</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>-42000</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>126058</TD> <TD>20250910</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>.........XXXXXXXXXX.XXXX.XXXXX.XXXXXXXX.</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-208</TD> <TD>61629</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>130552</TD> <TD>20250604</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XX.XXXXX..</TD> <TD>....XXX...</TD> <TD>-404</TD> <TD>40771</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 07 Nov 2025 21:01:56 GMT Jeff_DOC 2025-11-07T21:01:56Z Proc Compare Output Explanation https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978534#M378619 <P>Good afternoon.</P> <P>&nbsp;</P> <P>I am new to proc compare and I wondered if anyone could point me in the direction of any explanations to what the output values mean? It seems to work for me but I wanted to be sure I totally understood what each value in the output means (Ex. XXXX, E, ....,, -35, etc.). All the explanations I can find reference understanding the proc print output, but I wanted to see mine like this in tabular style. I can read the documentation myself but can't seem to find any.</P> <P>&nbsp;</P> <TABLE width="1848"> <TBODY> <TR> <TD width="48">_TYPE_</TD> <TD width="38">VAR1</TD> <TD width="49">VAR2</TD> <TD width="63">VAR3</TD> <TD width="38">VAR4</TD> <TD width="38">VAR5</TD> <TD width="39">VAR6</TD> <TD width="38">VAR7</TD> <TD width="38">VAR8</TD> <TD width="38">VAR9</TD> <TD width="45">VAR10</TD> <TD width="45">VAR11</TD> <TD width="45">VAR12</TD> <TD width="45">VAR13</TD> <TD width="47">VAR14</TD> <TD width="45">VAR15</TD> <TD width="68">VAR16</TD> <TD width="75">VAR17</TD> <TD width="45">VAR18</TD> <TD width="324">VAR19</TD> <TD width="45">VAR20</TD> <TD width="45">VAR21</TD> <TD width="45">VAR22</TD> <TD width="79">VAR23</TD> <TD width="47">VAR24</TD> <TD width="45">VAR25</TD> <TD width="47">VAR26</TD> <TD width="45">VAR27</TD> <TD width="79">VAR28</TD> <TD width="59">VAR29</TD> <TD width="54">VAR30</TD> <TD width="47">VAR31</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>32054</TD> <TD>20030613</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-120023</TD> <TD>31516</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>32054</TD> <TD>20250415</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXXXXXXXXXXXXXXXXXXXXX..XXXXXXXXXXX.XXX</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-610</TD> <TD>54344</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>33821</TD> <TD>20250721</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>34250</TD> <TD>20250702</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>..XXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXX.....</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-202</TD> <TD>-1999</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-299</TD> <TD>48017</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>35838</TD> <TD>20240723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-10285</TD> <TD>-9590</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>39678</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>-35</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>1016</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>44757</TD> <TD>20250705</TD> <TD>E</TD> <TD>-1</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>-2</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>.....X....</TD> <TD>E</TD> <TD>-581</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>48518</TD> <TD>20250722</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>59462</TD> <TD>20250425</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>XXXXXXXXXXXXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-305</TD> <TD>5723</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>61460</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>70</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>40688</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>67105</TD> <TD>20250514</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>...............XXXXXXXXXXXXXXXXXXXXX....</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-299</TD> <TD>-12740</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-299</TD> <TD>-12740</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>85268</TD> <TD>20250813</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>155</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>-20250812</TD> <TD>XXXXXXX...</TD> <TD>X</TD> <TD>...............XXXX.XX.XXXXXXX..........</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-98</TD> <TD>63097</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>86947</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>200</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>.XXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>21765</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>88047</TD> <TD>20250604</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>XXXXXXXXX...............................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>-93</TD> <TD>62136</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>92094</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>-42064</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>95910</TD> <TD>20250722</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96247</TD> <TD>20240813</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-10013</TD> <TD>58615</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96593</TD> <TD>20200114</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..................XXXX..............</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-9805</TD> <TD>-61513</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>96593</TD> <TD>20210409</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>.</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..................XXXX..............</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>XXXXXXXX..</TD> <TD>..........</TD> <TD>-9805</TD> <TD>-61513</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>101163</TD> <TD>20250723</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>........................................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXX...</TD> <TD>....XXX...</TD> <TD>-1</TD> <TD>-42000</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>126058</TD> <TD>20250910</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>X</TD> <TD>.........XXXXXXXXXX.XXXX.XXXXX.XXXXXXXX.</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XXXXXXXX..</TD> <TD>....XXX...</TD> <TD>-208</TD> <TD>61629</TD> </TR> <TR> <TD>DIF</TD> <TD>1</TD> <TD>130552</TD> <TD>20250604</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>X</TD> <TD>....</TD> <TD>....</TD> <TD>E</TD> <TD>E</TD> <TD>....</TD> <TD>....</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>..........</TD> <TD>.</TD> <TD>XXXX..XXX.XXXXXXXXXX....................</TD> <TD>E</TD> <TD>.</TD> <TD>....</TD> <TD>..........</TD> <TD>..........</TD> <TD>E</TD> <TD>E</TD> <TD>XXXX</TD> <TD>XX.XXXXX..</TD> <TD>....XXX...</TD> <TD>-404</TD> <TD>40771</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 07 Nov 2025 21:01:56 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978534#M378619 Jeff_DOC 2025-11-07T21:01:56Z Re: Proc Compare Output Explanation https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978537#M378621 <P>It looks like that data came from running PROC COMPARE with the OUT= option to create an output dataset?<BR /><BR />That is documented here:</P> <P><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1jbbrf1tztya8n1tju77t35dej9.htm#p0z9hrqb72tzq3n1wz8zyvi52w6s" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1jbbrf1tztya8n1tju77t35dej9.htm#p0z9hrqb72tzq3n1wz8zyvi52w6s</A></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Quentin_0-1762549892258.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/111209i9BFE0E8F29AC0990/image-size/medium?v=v2&amp;px=400" role="button" title="Quentin_0-1762549892258.png" alt="Quentin_0-1762549892258.png" /></span></P> <P>&nbsp;</P> Fri, 07 Nov 2025 21:11:41 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978537#M378621 Quentin 2025-11-07T21:11:41Z Re: Proc Compare Output Explanation https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978543#M378624 <P>That is exactly what I needed. Thank you so much!</P> Fri, 07 Nov 2025 22:30:27 GMT https://communities.sas.com/t5/SAS-Programming/Proc-Compare-Output-Explanation/m-p/978543#M378624 Jeff_DOC 2025-11-07T22:30:27Z