selecting certain observations

[jcis7]

Hello!

I'm trying to add a contact name and email address to only observations that are public (Type=1)  (vs private (Type=2)).

I know how to add the observations using sql for all types but no for certain types.

I still want to keep the private facilities in the dataset but just want to add the admins to the public facilities

Here's my code:

proc sql;

create table admins as

select *

from admin

LEFT JOIN

ON distcode=dist_code

quit;

Any help you can give is appreciated

[Reeza · Accepted solution]

Did your code get cut off? I only see reference to one table but a LEFT JOIN...

You can add a filter to your join using ON/AND

ie

left join lookup

on distcode=dist_code AND public=1;

quit;

[jcis7]

Thank  you very much