Hello, I'm trying to update admin contact name & email information from the 'PrivAdmins' table into the 'Facilities' table.
the 'PrivAdmins' table has more facility codes than the 'Facilities' table.
But I only want the contact info for those facility codes that are in Table A updated (I don't want to add the facility codes listed in only listed in Table B but not Table A).
PrivAdmins Table
FacilityCode AdminName AdminEmail
AdminAdmin admin@gmail.com /*this table has facility codes with missing values too*/
12345 Carla Lan carlalan@gmail.com
12346 Patrick Miles pmiles@dmac.org
Facilities Table
FacilityCode AdminName AdminEmail. FacilityName (more variables)...
12345 FacilityA
12349 Niger Kopak nk@cmac.com FacilityB
Desired Result (Adminsp table)
FacilityCode AdminName AdminEmail Facility Name (more variables)...
12345 Carla Lan caralan@gmail.com FacilityA
12349 Niger Kopak nk@cmac.com FacilityB
I used this code but it doesn't work.
data adminsp;
update facilities privadmins;
by facilitycode;
run;
Is this what you are looking for?
data Adminsp;
merge Facilities (in=in1) PrivAdmins (in=in2);
by FacilityCode;
if in1;
run;
If not, you might have to explain with more than "it doesn't work". What do you get vs. what do you need?
Good luck.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.