Hi i just tried your suggestion but it does not work i m wondering why when i use same condition with different tables it works as follows proc sql;
create table erm_var as select a.code,a.year1,a.sales,a.COGS,a.SE,a.M_cost,b.CSFO,c.INVentory,d.Total_assets,e.RDSpendSum,
f.indusCode
from alkebsee as a, radwan as b, zahra as c, reda as d, hassan as e, indus as f
where a.code=b.code=c.code=d.code=e.code=f.code and a.year1=b.year1=c.year1=d.year1=e.year1;
quit; 96 proc sql; 97 create table erm_var as select 97 ! a.code,a.year1,a.sales,a.COGS,a.SE,a.M_cost,b.CSFO,c.INVentory,d.Total_assets,e.RDSpendSum, 98 f.indusCode 99 from alkebsee as a, radwan as b, zahra as c, reda as d, hassan as e, indus as f 100 where a.code=b.code=c.code=d.code=e.code=f.code and a.year1=b.year1=c.year1=d.year1=e.year1; NOTE: Table WORK.ERM_VAR created, with 15196 rows and 11 columns. 101 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.21 seconds cpu time 0.18 seconds but when i use it with other tables it does not work as follows proc sql;
create table con_var as
select a.code,a.year1,a.gender,a.Total_pay,b.ROA,b.ROE,c.soe,d.boardsize,
d.number_of_independent_directors,e.INVentory,f.Total_assets,f.leverage,f.Recievables, g.indusCode
from indp as a, roft as b, soe as c, board as d, zahra as e, reda as f, indus AS g
where a.code=b.code=c.code=d.code=e.code=f.code=g.code
and a.year1=b.year1=c.year1=d.year1=e.year1=f.year1;
quit; 117 proc sql; 118 create table con_var as 119 select a.code,a.year1,a.gender,a.Total_pay,b.ROA,b.ROE,c.soe,d.boardsize, 120 d.number_of_independent_directors,e.INVentory,f.Total_assets,f.leverage,f.Recievables, 120! g.indusCode 121 from indp as a, roft as b, soe as c, board as d, zahra as e, reda as f, indus AS g 122 where a.code=b.code=c.code=d.code=e.code=f.code=g.code 123 and a.year1=b.year1=c.year1=d.year=e.year1=f.year1; ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using equals (=) has components that are of different data types. 124 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 could you please figure out the reason ?
... View more