topic Re: join tables in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167952#M43510 <HTML><HEAD></HEAD><BODY><P>select * from table1</P><P>union all </P><P>select * from table2</P></BODY></HTML> Wed, 20 Aug 2014 14:48:52 GMT Ksharp 2014-08-20T14:48:52Z join tables https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167949#M43507 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want to joint some tables.</P><P></P><P>table 1</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P></P><P>table2</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; </P><P>5&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>JOINT TABLE THAT I WANT </P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C</P><P><SPAN style="font-size: 10pt;">1&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>8&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp; </P><P>5&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; </P><P>2&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 3</P></BODY></HTML> Tue, 19 Aug 2014 20:04:44 GMT https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167949#M43507 sasphd 2014-08-19T20:04:44Z Re: join tables https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167950#M43508 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>set table1 table2;</P><P>run;</P></BODY></HTML> Tue, 19 Aug 2014 20:16:50 GMT https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167950#M43508 stat_sas 2014-08-19T20:16:50Z Re: join tables https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167951#M43509 <HTML><HEAD></HEAD><BODY><P><EM>Join</EM> is reserved for something else. What you want is <EM>concatenate</EM>:</P><P></P><P><STRONG>data join;</STRONG></P><P><STRONG>set table1 table2;</STRONG></P><P><STRONG>run;</STRONG></P><P></P><P>PG</P></BODY></HTML> Tue, 19 Aug 2014 20:21:45 GMT https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167951#M43509 PGStats 2014-08-19T20:21:45Z Re: join tables https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167952#M43510 <HTML><HEAD></HEAD><BODY><P>select * from table1</P><P>union all </P><P>select * from table2</P></BODY></HTML> Wed, 20 Aug 2014 14:48:52 GMT https://communities.sas.com/t5/SAS-Procedures/join-tables/m-p/167952#M43510 Ksharp 2014-08-20T14:48:52Z