topic How Do I Join Tables And Keep All Data in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785771#M250809 I need to join 6 tables that have identical column names and I want to keep all data. What’s the simplest way to do that? Mon, 13 Dec 2021 15:16:56 GMT NewToAllThis 2021-12-13T15:16:56Z How Do I Join Tables And Keep All Data https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785771#M250809 I need to join 6 tables that have identical column names and I want to keep all data. What’s the simplest way to do that? Mon, 13 Dec 2021 15:16:56 GMT https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785771#M250809 NewToAllThis 2021-12-13T15:16:56Z Re: How Do I Join Tables And Keep All Data https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785772#M250810 <P>What do you mean by "JOIN"?</P> <P>If they have the same variables then perhaps you should just stack them together.</P> <PRE><CODE class=" language-sas">data want; set tableA tableB table1-table4; run;</CODE></PRE> <P>&nbsp;</P> Mon, 13 Dec 2021 15:21:02 GMT https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785772#M250810 Tom 2021-12-13T15:21:02Z Re: How Do I Join Tables And Keep All Data https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785781#M250814 Yes sorry i need to stack them as they have same variables. Thanks this has done the trick <span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span> Mon, 13 Dec 2021 16:10:58 GMT https://communities.sas.com/t5/SAS-Programming/How-Do-I-Join-Tables-And-Keep-All-Data/m-p/785781#M250814 NewToAllThis 2021-12-13T16:10:58Z