topic Re: Create a new variable ,if values in One data set A is equal to values in another data set B then return values from second column in data set b in SAS Programming https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192202#M266184 <HTML><HEAD></HEAD><BODY><P>This is really nice , thank you .. Anca</P></BODY></HTML> Wed, 05 Mar 2014 11:48:53 GMT boin 2014-03-05T11:48:53Z Create a new variable ,if values in One data set A is equal to values in another data set B then return values from second column in data set b https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192200#M266182 <HTML><HEAD></HEAD><BODY><UL><LI>I Have a data set with the below values</LI></UL><P><STRONG>Employee</STRONG>&nbsp;&nbsp; <STRONG>Manager</STRONG></P><P>sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Niro</P><P>kevin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daniel</P><P>george&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peter</P><P>niro&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P>daniel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David</P><P>peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P>david&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P></P><P>another data set</P><P><STRONG>EMPLOYEE</STRONG></P><P>sam</P><P>kevin</P><P>george</P><P>niro</P><P>daniel</P><P>peter</P><P>david</P><P>leo</P><P></P><P></P><P>i want the output the output data set to be</P><P><STRONG>employee</STRONG>&nbsp; <STRONG>Manager</STRONG></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Niro</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">kevin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daniel</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> George&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peter</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">niro&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">daniel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">david&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">leo</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">please assist with the above.. <BR /></SPAN></P></BODY></HTML> Tue, 04 Mar 2014 10:59:41 GMT https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192200#M266182 boin 2014-03-04T10:59:41Z Re: Create a new variable ,if values in One data set A is equal to values in another data set B then return values from second column in data set b https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192201#M266183 <HTML><HEAD></HEAD><BODY><P>How about this?;</P><P></P><P>data one;</P><P>input Employee&nbsp; $ Manager $;</P><P>datalines;</P><P>sam&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Niro</P><P>kevin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daniel</P><P>george&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Peter</P><P>niro&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P>daniel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David</P><P>peter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P>david&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Leo</P><P>;</P><P></P><P>data two;</P><P>input EMPLOYEE $;</P><P>datalines;</P><P>sam</P><P>kevin</P><P>george</P><P>niro</P><P>daniel</P><P>peter</P><P>david</P><P>leo</P><P>;</P><P>proc sort data = one;by employee;</P><P>proc sort data = two;by employee;</P><P></P><P>data want;</P><P>&nbsp;&nbsp;&nbsp; merge one two;</P><P>&nbsp;&nbsp;&nbsp; by employee;</P><P>run;</P><P></P><P>Good luck,</P><P>Anca.</P><P></P><P>*alternatively;</P><P>proc sql;</P><P>&nbsp;&nbsp;&nbsp; create table want as</P><P>&nbsp;&nbsp;&nbsp; select a.manager,b.employee</P><P>&nbsp;&nbsp;&nbsp; from one as a full join two as b</P><P>&nbsp;&nbsp;&nbsp; on a.employee = b.employee;</P><P>quit;</P></BODY></HTML> Tue, 04 Mar 2014 13:18:46 GMT https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192201#M266183 AncaTilea 2014-03-04T13:18:46Z Re: Create a new variable ,if values in One data set A is equal to values in another data set B then return values from second column in data set b https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192202#M266184 <HTML><HEAD></HEAD><BODY><P>This is really nice , thank you .. Anca</P></BODY></HTML> Wed, 05 Mar 2014 11:48:53 GMT https://communities.sas.com/t5/SAS-Programming/Create-a-new-variable-if-values-in-One-data-set-A-is-equal-to/m-p/192202#M266184 boin 2014-03-05T11:48:53Z