topic Re: selecting certain observations in SAS Procedures

selecting certain observations

jcis7 — Tue, 24 Feb 2015 17:55:55 GMT

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 — Tue, 24 Feb 2015 18:06:41 GMT

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

left join lookup

on distcode=dist_code AND public=1;

quit;

jcis7 — Tue, 24 Feb 2015 19:24:02 GMT

Thank you very much