Good Day everyone. Apologies for the late reply, but we decided to go with an alternative approach. Instead of merging the 2 data sets, we are now filtering the second data set based on the national_id in the first data set. In this manner and for our purposes, we avoid the need for merging in the first place, thus being able to run a PROC SQL statement such as the below without issue: proc sql;
create table destfp.finalds_20200131 as
select * from destfp.secondds_20200131
where id_no in (select distinct person_id from dsfirst.firstds_202001);
quit; Yes, it is still a PROC SQL statement, however since we're not doing a join and the resultant data set is roughly a tenth of the size of the second data set, we are happy with the outcome. Unfortunately, due to the sensitivity of the data we are working with, I am not able to post sample data, however the code is a near-identical representation of the actual code we are running. Thanks everyone for the assistance. Special mention to @yabwon and @Kurt_Bremser for their ideas. Much appreciated.
... View more
