topic Re: How to find if an observation or ID is in multiple table ? in SAS Programming

How to find if an observation or ID is in multiple table ?

bersys02 — Fri, 15 Jan 2021 00:30:29 GMT

Hello,

I am trying to find out how many ID's/observations/persons are in different tables or variables ? For instance, if I want to find how the number of people who has multiple nationalities or more than 1. How can I code this ?

Thank you.

Re: How to find if an observation or ID is in multiple table ?

tarheel13 — Fri, 15 Jan 2021 01:03:06 GMT

Post some data if you can. Hard to help you without seeing it.

Re: How to find if an observation or ID is in multiple table ?

andreas_lds — Fri, 15 Jan 2021 06:18:32 GMT

Hardly possible to suggest something useful without more information. So please post example data in usable form (a data step using datalines).

Re: How to find if an observation or ID is in multiple table ?

Ksharp — Fri, 15 Jan 2021 11:36:15 GMT

proc sql;
select id from a
intersect
select id from b
intersect
select id from c
............
;
quit;