Hello everyone I have run the following code proc sql;
create table me AS SELECT a.n_cfo,a.n_prod,a.n_disexp,b.Is_there_any_defect_in_internal,c.Fraud_Dummy
from real as a, defect as b
full join violation as c
on a.code=b.code=c.code and a.year=b.year=c.year;
quit; but i got the following message 62 proc sql; 63 create table me AS SELECT 63 ! a.n_cfo,a.n_prod,a.n_disexp,b.Is_there_any_defect_in_internal,c.Fraud_Dummy 64 from real as a, defect as b 65 full join violation as c 66 on a.code=b.code=c.code and a.year=b.year=c.year; ERROR: Correlated reference to column code is not contained within a subquery. ERROR: Correlated reference to column year is not contained within a subquery. 67 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.03 seconds ### so i do not know where the error i checked my data very well please explain such an error.
... View more
