topic Update of variables in SAS Programming

Update of variables

WilliamB — Tue, 24 Apr 2018 13:25:36 GMT

Hello,

I have two tables, one that corresponds to the inventory and the second to the dictionary.

The problem is that missing values in my first table, names are missing.

I would like to have a sql program if possible to complete the missing values.

Thanks for your help.

And get this

Kurt_Bremser — Tue, 24 Apr 2018 13:31:24 GMT

SQL:

proc sql;
create table want as
select
  a.ID,
  coalesce(a.name,b.name) as name,
  a.sell
from table1 a left join table2 b
on a.id = b.id;
quit;

Data step:

data want;
merge
  table1 (in=a)
  tableb (in=b rename=(name=_name))
;
by id;
if a;
if b and name = ' ' then name = _name;
drop _name;
run;

Tables must be sorted by id for the data step merge.

Ksharp — Tue, 24 Apr 2018 13:34:41 GMT

CODE NOT TESTED.

proc sql;

select a.id, coalescec(a.name,b.name) as name, a.sell

from table1 as a left join table2 as b

on a.id=b.id ;

quit;