hi,
We have a table (table_a) on sql server such as
id 1/1/2017 2/1/2017 3/1/2017 4/1/2017
---------------------------------------------------------------
10 123 555 null null
11 456 666 null null
meaning that table has not been updated with this month data yet which i have as a dataset:(table_b)
id 3/1/2017
--------------------
10 189
11 123
what is the best way to update table_a?
i am thinking of
create table_a as select *from table_a,table_b where a.oid=b.oid;quit;
but that is kinda overwriting a table and dont know how to do this using "update table_a" as i am not adding rows to table_a but actually adding columns
I am doing this in SAS and the dataset i have has about 200 records
any one please?
thx
... View more
