How to Update

jcis7 — Tue, 24 Feb 2015 21:25:44 GMT

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;

Re: How to Update

Astounding — Tue, 24 Feb 2015 22:12:01 GMT

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.

topic Re: How to Update in SAS Procedures

How to Update

Re: How to Update