topic Re: How to merge two datasets with same ID and replace data on the blank in SAS Programming

How to merge two datasets with same ID and replace data on the blank

ttqkroe — Thu, 21 Oct 2021 07:11:22 GMT

ID	a	b	c	d
1		1	1	1
1		2	2	2
1	b	3	3	3
1		4	4	4

ID	a
1	c

The result should look like:

ID	a	b	c	d
1	c	1	1	1
1	c	2	2	2
1	b	3	3	3
1	c	4	4	4

Thanks!!!

Re: How to merge two datasets with same ID and replace data on the blank

PeterClemmensen — Thu, 21 Oct 2021 07:19:54 GMT

Does your second data set always have just one obs?

Re: How to merge two datasets with same ID and replace data on the blank

ttqkroe — Thu, 21 Oct 2021 07:20:43 GMT

Yes

Re: How to merge two datasets with same ID and replace data on the blank

Kurt_Bremser — Thu, 21 Oct 2021 07:22:04 GMT

proc sql;
create table want as
  select
    t1.id,
    coalesce(t1.a,t2.a) as a,
    t1.b,
    t1.c,
    t1.d
  from have t1 left join upd t2
  on t1.id = t2.id
;
quit;

Re: How to merge two datasets with same ID and replace data on the blank

PeterClemmensen — Thu, 21 Oct 2021 07:35:59 GMT

data one;
infile datalines dlm = ',' missover dsd;
input ID a $ b c d;
datalines;
1, ,1,1,1
1, ,2,2,2
1,b,3,3,3
1, ,4,4,4
;

 
data two;
input ID a $;
datalines;
1 c
;

data want;
   set one;
   z = 1;
   if a = "" then set two point = z; 
run;