https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578608#M164122 Two questions are critical to providing the best answer.<BR /><BR />What should happen when both data sets contain a nonmissing value for WEIGHT, but the values are different?<BR /><BR />Should Juan, who appears only in data set 2, really be omitted from the final result? Fri, 02 Aug 2019 03:03:20 GMT Astounding 2019-08-02T03:03:20Z https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578602#M164117 <P>Hi everyone.</P><P>&nbsp;</P><P>I have two large data sets.</P><P>Data1 is my main data set with missing information. I need to get that information in Data2 to fill the gap in Data1.</P><P>&nbsp;</P><P><STRONG>Data1</STRONG></P><P><EM><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Weight</STRONG></EM></P><P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22Nov16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp;&nbsp;</P><P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;&nbsp;</P><P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05May21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 105&nbsp;</P><P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>&nbsp;</P><P><STRONG>Data2</STRONG></P><P><EM><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight</STRONG></EM></P><P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 110</P><P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp;&nbsp;</P><P>Juan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12Aug21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75</P><P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;na</P><P>&nbsp;</P><P>&nbsp;</P><P>So my final data set would like the one below.</P><P>&nbsp;</P><P><STRONG>Final data</STRONG></P><P><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Weight</STRONG></P><P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22Nov16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp;&nbsp;</P><P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG> 110&nbsp;</STRONG></P><P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>3</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;&nbsp;</P><P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05May21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 105&nbsp;</P><P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1&nbsp;</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG> &nbsp;na</STRONG>&nbsp;</P><P>&nbsp;</P><P>Thank you very much in advance for your help!</P> Fri, 02 Aug 2019 02:03:35 GMT https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578602#M164117 yoyong555 2019-08-02T02:03:35Z https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578603#M164118 <P>Assuming data is sorted by Name and ID and you can merge by those.&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; merge data1 (rename = (smoking_status = smoke1 weight = weight1)) data2 (rename = (smoking_status = smoke2 weight = weight2)); by name admission_date; smoking_status = coalesce(smoke1, smoke2); weight = coalesce(weight1, weight2); run;</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/276208">@yoyong555</a>&nbsp;wrote:<BR /> <P>Hi everyone.</P> <P>&nbsp;</P> <P>I have two large data sets.</P> <P>Data1 is my main data set with missing information. I need to get that information in Data2 to fill the gap in Data1.</P> <P>&nbsp;</P> <P><STRONG>Data1</STRONG></P> <P><EM><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Weight</STRONG></EM></P> <P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22Nov16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;&nbsp;</P> <P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P> <P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05May21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 105&nbsp;</P> <P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>&nbsp;</P> <P><STRONG>Data2</STRONG></P> <P><EM><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Weight</STRONG></EM></P> <P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 110</P> <P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>Juan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12Aug21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;75</P> <P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;na</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>So my final data set would like the one below.</P> <P>&nbsp;</P> <P><STRONG>Final data</STRONG></P> <P><STRONG>Name&nbsp; &nbsp; &nbsp; &nbsp; Admission_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Smoking_Status&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Weight</STRONG></P> <P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22Nov16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp;&nbsp;</P> <P>Maria&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10Dec20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG> 110&nbsp;</STRONG></P> <P>Luna&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 02Jan15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>3</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;&nbsp;</P> <P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18Mar19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P> <P>Rey&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05May21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 105&nbsp;</P> <P>Jim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13Sep14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>1&nbsp;</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG> &nbsp;na</STRONG>&nbsp;</P> <P>&nbsp;</P> <P>Thank you very much in advance for your help!</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Fri, 02 Aug 2019 02:32:53 GMT https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578603#M164118 Reeza 2019-08-02T02:32:53Z https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578608#M164122 Two questions are critical to providing the best answer.<BR /><BR />What should happen when both data sets contain a nonmissing value for WEIGHT, but the values are different?<BR /><BR />Should Juan, who appears only in data set 2, really be omitted from the final result? Fri, 02 Aug 2019 03:03:20 GMT https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578608#M164122 Astounding 2019-08-02T03:03:20Z https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578670#M164162 <PRE class=" language-sas"><CODE class=" language-sas"><SPAN class="token procnames">data</SPAN> want<SPAN class="token punctuation">;</SPAN> <SPAN class="token keyword">update</SPAN> data1 data2<SPAN class="token punctuation">;</SPAN> <SPAN class="token statement">by</SPAN> name admission_date;<BR />run;</CODE></PRE> Fri, 02 Aug 2019 11:55:10 GMT https://communities.sas.com/t5/SAS-Programming/merging-two-datasets/m-p/578670#M164162 Ksharp 2019-08-02T11:55:10Z