How to Update

[jcis7]

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;

[Astounding]

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.