How Do I Join Tables And Keep All Data

[NewToAllThis]

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?

[Tom]

What do you mean by "JOIN"?

If they have the same variables then perhaps you should just stack them together.

data want;
  set tableA tableB table1-table4;
run;

[NewToAllThis]

Yes sorry i need to stack them as they have same variables. Thanks this has done the trick 😁