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
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;
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;
Thank you very much
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.