By efficient, do you mean the time it would take to write the program?
If your variables that you want to be in the some output variable have the same positions in the input data sets, you can use the UNION ALL operator in SQL, since it doesn't care about variable names (except the one from the first table).
... View more
