topic Re: Help with merge in SAS Programming https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91169#M19274 <HTML><HEAD></HEAD><BODY><P>Thank you Shivas, worked great!!</P></BODY></HTML> Mon, 25 Jun 2012 08:16:53 GMT Havi 2012-06-25T08:16:53Z Help with merge https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91167#M19272 <HTML><HEAD></HEAD><BODY><P><BR />Hi All</P><P></P><P>Please help, I have two datasets:</P><P></P><P>Name&nbsp;&nbsp;&nbsp; Acc&nbsp;&nbsp;&nbsp;&nbsp; Code<BR />Shop1&nbsp; A0001&nbsp;&nbsp; Stationery<BR />Shop2&nbsp; A0002&nbsp;&nbsp; Clothes<BR />Shop3&nbsp; A0003&nbsp;&nbsp; Groceries</P><P></P><P><BR />Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Phone_Number<BR />01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000009<BR />01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000010<BR />01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000011<BR />01MAY2012&nbsp;&nbsp; A0002&nbsp; 00112000555<BR />01MAY2012&nbsp;&nbsp; A0002&nbsp; 00112000666<BR />01MAY2012&nbsp;&nbsp; A0003&nbsp; 00112005678</P><P><BR />I want to merge the two datasets to achieve the below dataset:</P><P></P><P></P><P>Date :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acc:&nbsp;&nbsp; Phone_Number:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name:&nbsp;&nbsp;&nbsp; Code:<BR />01MAY2012&nbsp;&nbsp; A0001&nbsp;&nbsp; 00112000009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop1&nbsp; Stationery<BR />01MAY2012&nbsp;&nbsp; A0001&nbsp;&nbsp; 00112000010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop1&nbsp; Stationery <BR />01MAY2012&nbsp;&nbsp; A0001&nbsp;&nbsp; 00112000011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop1&nbsp; Stationery<BR />01MAY2012&nbsp;&nbsp; A0002&nbsp;&nbsp; 00112000555&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop2&nbsp; Clothes<BR />01MAY2012&nbsp;&nbsp; A0002&nbsp;&nbsp; 00112000666&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop2&nbsp; Clothes<BR />01MAY2012&nbsp;&nbsp; A0003&nbsp;&nbsp; 00112005678&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Shop3&nbsp; Groceries</P><P></P><P></P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 25 Jun 2012 07:51:33 GMT https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91167#M19272 Havi 2012-06-25T07:51:33Z Re: Help with merge https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91168#M19273 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this..Hope it helps..</P><P> data one;</P><P> input Name $&nbsp;&nbsp; Acc $&nbsp;&nbsp; Code $ 20.;</P><P> cards;</P><P>Shop1&nbsp; A0001&nbsp;&nbsp; Stationery</P><P>Shop2&nbsp; A0002&nbsp;&nbsp; Clothes</P><P>Shop3&nbsp; A0003&nbsp;&nbsp; Groceries</P><P>;</P><P>run;</P><P>data two;</P><P>input Date Acc $&nbsp; Phone_Number;</P><P>informat Date date9.;</P><P>format&nbsp; Date date9.;</P><P>cards;</P><P>01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000009</P><P>01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000010</P><P>01MAY2012&nbsp;&nbsp; A0001&nbsp; 00112000011</P><P>01MAY2012&nbsp;&nbsp; A0002&nbsp; 00112000555</P><P>01MAY2012&nbsp;&nbsp; A0002&nbsp; 00112000666</P><P>01MAY2012&nbsp;&nbsp; A0003&nbsp; 00112005678</P><P>;</P><P>run;</P><P>data want;</P><P>merge one(in=a) two(in=b);</P><P>by acc;</P><P>if a;</P><P>run;</P><P></P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Mon, 25 Jun 2012 08:04:32 GMT https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91168#M19273 shivas 2012-06-25T08:04:32Z Re: Help with merge https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91169#M19274 <HTML><HEAD></HEAD><BODY><P>Thank you Shivas, worked great!!</P></BODY></HTML> Mon, 25 Jun 2012 08:16:53 GMT https://communities.sas.com/t5/SAS-Programming/Help-with-merge/m-p/91169#M19274 Havi 2012-06-25T08:16:53Z