topic Re: How Do I Sum a column that is a calculated by two other columns in SAS Enterprise Guide

How Do I Sum a column that is a calculated by two other columns

Kelvin156 — Wed, 23 Nov 2016 14:31:37 GMT

Hi,

Is it possible during the proc sql code below to add another column which would be 'Total' (Bal1+BAl2+BAl3)-(Bal4+Bal5+Bal6+BAl6)

Or to do it as a seperate data step after the output of the following code?

proc sql;
connect to &ABCD as ABC(ACCDE);
create table TestBal as
select *
from connection to ABC
(
select
AccountNum as Accno,
Bal1,
Bal2,
Bal3,
Bal4,
Bal5,
Bal6,
Bal7,
Load_Date

from Table.Dataset

order by Accno

);
disconnect from ABC;
quit;

Re: How Do I Sum a column that is a calculated by two other columns

Kurt_Bremser — Wed, 23 Nov 2016 14:51:13 GMT

select
AccountNum as Accno,
Bal1,
Bal2,
Bal3,
Bal4,
Bal5,
Bal6,
Bal7,
Load_Date,
(Bal1+BAl2+BAl3)-(Bal4+Bal5+Bal6+BAl6) as Total

Re: How Do I Sum a column that is a calculated by two other columns

Kelvin156 — Wed, 23 Nov 2016 15:15:46 GMT

Thank You Very Much