topic Re: NODUPKEY and by _ALL_ with adjacent confusion? in SAS Programming https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730313#M227392 <P>"Adjacent" here means "adjacent after the sort".</P> Wed, 31 Mar 2021 06:46:34 GMT Kurt_Bremser 2021-03-31T06:46:34Z NODUPKEY and by _ALL_ with adjacent confusion? https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730310#M227390 <P>Hi all SAS Users,</P><P>&nbsp;</P><P>I am learning some courses provided by SAS, today when I reviewed the material, I saw this sentence.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ResoluteCarbon_0-1617172322930.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/56731i6FE7683F622AF963/image-size/large?v=v2&amp;px=999" role="button" title="ResoluteCarbon_0-1617172322930.png" alt="ResoluteCarbon_0-1617172322930.png" /></span></P><P>&nbsp;</P><P>I am from a country that English is a second language, so from what I know,<STRONG> adjacent</STRONG> means that two rows continuously in this case. So, if these two rows are not continuously, how come we exclude the totally duplicated rows?</P><P>&nbsp;</P><P>Thank you in advance.</P> Wed, 31 Mar 2021 06:34:05 GMT https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730310#M227390 ResoluteCarbon 2021-03-31T06:34:05Z Re: NODUPKEY and by _ALL_ with adjacent confusion? https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730313#M227392 <P>"Adjacent" here means "adjacent after the sort".</P> Wed, 31 Mar 2021 06:46:34 GMT https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730313#M227392 Kurt_Bremser 2021-03-31T06:46:34Z Re: NODUPKEY and by _ALL_ with adjacent confusion? https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730323#M227399 <P>The explanation would have been clearer (and obviously less confusing, since it confused you) if the word <EM>adjacent</EM> had been omitted. This word brings no value here.</P> <P>It's probably a leftover from an explanation about the NODUPREC option, and should be removed here.</P> Wed, 31 Mar 2021 08:00:37 GMT https://communities.sas.com/t5/SAS-Programming/NODUPKEY-and-by-ALL-with-adjacent-confusion/m-p/730323#M227399 ChrisNZ 2021-03-31T08:00:37Z