https://communities.sas.com/t5/SAS-Programming/SQL-equivalent/m-p/231208#M42037 <P>Union All will include duplicates.&nbsp; Union will remove duplicates:</P><P>&nbsp;</P><P>proc sql;<BR />create table table1 as<BR />select obs2,obs4<BR />from table2<BR />union<BR />select obs2,obs4<BR />from table3<BR />union<BR />select obs2,obs4<BR />from table4;</P> Thu, 22 Oct 2015 16:36:57 GMT Steelers_In_DC 2015-10-22T16:36:57Z https://communities.sas.com/t5/SAS-Programming/SQL-equivalent/m-p/231207#M42036 <PRE><CODE class=" language-sas">DATA TABLE1; SET TABLE2 TABLE3 TABLE4; KEEP OBS2 OBS4; RUN;</CODE></PRE> Thu, 22 Oct 2015 16:31:25 GMT https://communities.sas.com/t5/SAS-Programming/SQL-equivalent/m-p/231207#M42036 G_I_Jeff 2015-10-22T16:31:25Z https://communities.sas.com/t5/SAS-Programming/SQL-equivalent/m-p/231208#M42037 <P>Union All will include duplicates.&nbsp; Union will remove duplicates:</P><P>&nbsp;</P><P>proc sql;<BR />create table table1 as<BR />select obs2,obs4<BR />from table2<BR />union<BR />select obs2,obs4<BR />from table3<BR />union<BR />select obs2,obs4<BR />from table4;</P> Thu, 22 Oct 2015 16:36:57 GMT https://communities.sas.com/t5/SAS-Programming/SQL-equivalent/m-p/231208#M42037 Steelers_In_DC 2015-10-22T16:36:57Z