Hello everyone please someone explain to me how to solve the error (ERROR 79-322: Expecting a ). when i run this code proc sql;
create table main_vars as
select a.code, a.year1,
a.TA,a.TCA,a.cash,a.RECE,a.TCL,a.Depreciation,a.DCL,b.gross_revenue,d.OPERATION_CASH_FLOW,d.INVT_CASH_FLOW
from radwan4 as a, alkebsee1 as b, cashflow as d
where a.code=b,code=d.code and a.year1=b.year1=d.year1;
quit; i got this error message 126 proc sql; 127 create table main_vars as 128 select a.code, a.year1, 129 a.TA,a.TCA,a.cash,a.RECE,a.TCL,a.Depreciation,a.DCL,b.gross_revenue,d.OPERATION_CASH_FLOW,d.INVT_ 129! CASH_FLOW 130 from radwan4 as a, alkebsee1 as b, cashflow as d 131 where a.code=b,code=d.code and a.year1=b.year1=d.year1; - 79 131 where a.code=b,code=d.code and a.year1=b.year1=d.year1; - 79 ERROR 79-322: Expecting a (. ERROR 79-322: Expecting a ). 132 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.03 seconds
... View more