I have to datasets with two variables (ID, Value). Each observation in each table is unique. How to I get enterprise guide to build the union query to form one dataset with one variable (value). I want to end up with one dataset listing all unique value varibles.
I know how to write a proc sql, but I want the gui to do it.