An efficient method to concatenating/stac datasets with multiple length for the character variables

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Lapis Lazuli | Level 10

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

Posted 09-16-2021 12:53 PM (587 views) | In reply to 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 🙂

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.