How to subtract values to update one variable with Update statement?

David_Billa — Thu, 16 Apr 2020 13:05:35 GMT

I need a help to know to update one field based on the subtraction of two variables from other datasets. Code which I use is shown below.

Here I want to update error_count value and it should subtract table_count_hub value from table_count value from run_id_received dataset

proc sql noprint;

create table run_id_received as

select run_id,table_count,table_count_hub,error_count

from status;

proc sql;

update main.status

set table_count_hub =(select table_count_hub from run_id_received),

error_count =??? /*I want to subtract table_count_hub value from table_count value from run_id_received dataset*/

;

quit;

Re: How to subtract values to update one variable with Update statement?

ChrisNZ — Tue, 21 Apr 2020 06:21:48 GMT

Please provide us with a 5-line data example of the before and after tables.