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;
... View more