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

varmalh — Tue, 17 Sep 2019 02:42:39 GMT

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

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

PGStats — Tue, 17 Sep 2019 02:53:16 GMT

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

topic What is the updated salary of each employee using SQL....? in SAS Programming

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

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