topic Overlap of common column in two different datasets in SAS Programming

Overlap of common column in two different datasets

buechler66 — Tue, 11 Dec 2018 21:14:10 GMT

Hi. I have two different datasets named my_data and other_data. Both datasets have an id variable that is 10 char. The first dataset's id variable is named my_id and the later is other_id.

I'm wondering what is the best way to query a list of ids that appear in both datasets?

Any help would be greatly appreciated. Thanks.

Re: Overlap of common column in two different datasets

Astounding — Tue, 11 Dec 2018 21:20:33 GMT

SQL handles this pretty well, along the lines of:

proc sql;

create table want as

select my_id from my_date

where my_id in (select distinct other_id from other_data);

quit;

Re: Overlap of common column in two different datasets

buechler66 — Tue, 11 Dec 2018 21:33:49 GMT

Oh, very simple. Thank you for taking the time to help. Much appreciated.