topic Matching on a non-unique variable ? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457460#M115987 <P><U>Nomatch</U> contains the list of students who have no access_code nor a link. I put in a request for these students and received a file named <U>Extra_codes</U> that has a code and a link for each student. The access_code is unique but the link is unique only to the school.&nbsp;</P> <P>&nbsp;</P> <P>I want to "transfer" the access_code and link from <U>Extra_codes</U> to <U>Nomatch.&nbsp;&nbsp;</U>&nbsp; (a copy/paste, if you will).</P> <P>&nbsp;</P> <P>The n count of school in Nomatch is the same as the n count of schoolname in Extra_codes.</P> <P>&nbsp;</P> <P>My 2 data sets:</P> <P>&nbsp;</P> <P><U>Nomatch</U></P> <P>school&nbsp; &nbsp; &nbsp; &nbsp; last&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;first&nbsp; &nbsp; &nbsp; &nbsp; access_code link</P> <P>east high&nbsp; &nbsp; able&nbsp; &nbsp; &nbsp; &nbsp; hotel&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>east high&nbsp; &nbsp; baker&nbsp; &nbsp; &nbsp; india&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>west elem&nbsp; charlie&nbsp; &nbsp; juliet&nbsp; &nbsp; &nbsp; &nbsp;</P> <P>west elem&nbsp; delta&nbsp; &nbsp; &nbsp; &nbsp;kilo&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>north mid&nbsp; &nbsp; echo&nbsp; &nbsp; &nbsp; lima</P> <P>north mid&nbsp; &nbsp; foxtrot&nbsp; &nbsp; mike</P> <P>north mid&nbsp; &nbsp; golf&nbsp; &nbsp; &nbsp; &nbsp; nove</P> <P>&nbsp;</P> <P><U>Extra_Codes</U></P> <P>schoolname&nbsp; &nbsp; &nbsp;access_code&nbsp; &nbsp; &nbsp; &nbsp; link</P> <P>east high&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <A href="https://lovesas.com/43" target="_blank">https://lovesas.com/43</A></P> <P>east high&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/43" target="_blank">https://lovesas.com/43</A></SPAN></P> <P>west elem&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 77&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/55" target="_blank">https://lovesas.com/55</A></SPAN></P> <P>west elem&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/55" target="_blank">https://lovesas.com/55</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> Wed, 25 Apr 2018 19:14:04 GMT GreggB 2018-04-25T19:14:04Z Matching on a non-unique variable ? https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457460#M115987 <P><U>Nomatch</U> contains the list of students who have no access_code nor a link. I put in a request for these students and received a file named <U>Extra_codes</U> that has a code and a link for each student. The access_code is unique but the link is unique only to the school.&nbsp;</P> <P>&nbsp;</P> <P>I want to "transfer" the access_code and link from <U>Extra_codes</U> to <U>Nomatch.&nbsp;&nbsp;</U>&nbsp; (a copy/paste, if you will).</P> <P>&nbsp;</P> <P>The n count of school in Nomatch is the same as the n count of schoolname in Extra_codes.</P> <P>&nbsp;</P> <P>My 2 data sets:</P> <P>&nbsp;</P> <P><U>Nomatch</U></P> <P>school&nbsp; &nbsp; &nbsp; &nbsp; last&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;first&nbsp; &nbsp; &nbsp; &nbsp; access_code link</P> <P>east high&nbsp; &nbsp; able&nbsp; &nbsp; &nbsp; &nbsp; hotel&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>east high&nbsp; &nbsp; baker&nbsp; &nbsp; &nbsp; india&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>west elem&nbsp; charlie&nbsp; &nbsp; juliet&nbsp; &nbsp; &nbsp; &nbsp;</P> <P>west elem&nbsp; delta&nbsp; &nbsp; &nbsp; &nbsp;kilo&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>north mid&nbsp; &nbsp; echo&nbsp; &nbsp; &nbsp; lima</P> <P>north mid&nbsp; &nbsp; foxtrot&nbsp; &nbsp; mike</P> <P>north mid&nbsp; &nbsp; golf&nbsp; &nbsp; &nbsp; &nbsp; nove</P> <P>&nbsp;</P> <P><U>Extra_Codes</U></P> <P>schoolname&nbsp; &nbsp; &nbsp;access_code&nbsp; &nbsp; &nbsp; &nbsp; link</P> <P>east high&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <A href="https://lovesas.com/43" target="_blank">https://lovesas.com/43</A></P> <P>east high&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/43" target="_blank">https://lovesas.com/43</A></SPAN></P> <P>west elem&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 77&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/55" target="_blank">https://lovesas.com/55</A></SPAN></P> <P>west elem&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/55" target="_blank">https://lovesas.com/55</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;89&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> <P>north mid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<SPAN><A href="https://lovesas.com/98" target="_blank">https://lovesas.com/98</A></SPAN></P> Wed, 25 Apr 2018 19:14:04 GMT https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457460#M115987 GreggB 2018-04-25T19:14:04Z Re: Matching on a non-unique variable ? https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457472#M115990 <P>if the count does match and the order of the data is as you need then this might be as simple as</P> <P>&nbsp;</P> <P>data want;</P> <P>&nbsp;&nbsp; merge nomatch extra_codes;</P> <P>run;</P> <P>&nbsp;</P> <P>Though if the code value of 22 is supposed to go with baker india instead of able hotel then more details needed.</P> Wed, 25 Apr 2018 19:28:33 GMT https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457472#M115990 ballardw 2018-04-25T19:28:33Z Re: Matching on a non-unique variable ? https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457488#M115992 thanks. all that matters is that baker and able get codes that belong to east high. Wed, 25 Apr 2018 19:46:35 GMT https://communities.sas.com/t5/SAS-Programming/Matching-on-a-non-unique-variable/m-p/457488#M115992 GreggB 2018-04-25T19:46:35Z