What is the updated salary of each employee using SQL....?

[varmalh]

Hello all,

can someone please help me to get the same output from SQL as i am getting from base SAS from the below code....????

data a;
input emp$ sal;
cards;
emp1 1000000
emp2 2000000
emp3 3000000
;run;

data b;
input emp$ sal;
cards;
emp1 1000000
emp3 7000000
emp4 4000000
;run;

data c;
update a b;
by emp;
run;

data c;
merge a(in=x) b(in=y);
by emp;
run;

 output should be like below:

---------------------

emp1 1000000
emp2 2000000
emp3 7000000
emp4 4000000

---------------------

Thanks and Regards

varmalh

[PGStats · Accepted solution]

proc sql;
select 
	coalesce(b.emp, a.emp) as emp,
	coalesce(b.sal, a.sal) as sal
from a full outer join b on a.emp=b.emp;
quit;

---

@varmalh wrote:

Hello all,

can someone please help me to get the same output from SQL as i am getting from base SAS from the below code....????

data a;
input emp$ sal;
cards;
emp1 1000000
emp2 2000000
emp3 3000000
;run;

data b;
input emp$ sal;
cards;
emp1 1000000
emp3 7000000
emp4 4000000
;run;

data c;
update a b;
by emp;
run;

data c;
merge a(in=x) b(in=y);
by emp;
run;

 output should be like below:

---------------------

emp1 1000000
emp2 2000000
emp3 7000000
emp4 4000000

---------------------

Thanks and Regards

varmalh

---