An efficient method to merge datasets with multiple length for the character variables

[Emma_at_SAS]

I found the solution for the case when we have non-matching variables in each dataset:

proc sql;
create table want as
select * from d1 
OUTER UNION CORR
select * from d2;
quit;

Thanks for introducing this PROC SQL procedure. It was very helpful 🙂