Hi thank you for replies. The code was correct. I downsized my datasets and posted here. The issue is not about the file name. I copied the code I was using thats why the old file name was in the earlier post. The log shows the following: 1162 proc sql; 1162! create table perm.Mergedtemp22 as select 1163 a.*, b.conm, b.ipodate, b.cik,b.roa, b.LnAT, b.turn, b.DTE,b.OCFA, b.TACC,b.MVE,b.BTM 1164 from perm.Mergedtemp21 as a left join perm.compustatnew4 as b 1165 on a.gvkey2=b.gvkey 1166 and a.year eq b.year 1167 and a.calendarquarter eq b.calendarquarter 1168 order by permno, mergerdateannounced; WARNING: Variable CONM already exists on file PERM.MERGEDTEMP22. WARNING: Variable IPODATE already exists on file PERM.MERGEDTEMP22. WARNING: Variable CIK already exists on file PERM.MERGEDTEMP22. WARNING: Variable ROA already exists on file PERM.MERGEDTEMP22. WARNING: Variable LnAT already exists on file PERM.MERGEDTEMP22. WARNING: Variable TURN already exists on file PERM.MERGEDTEMP22. WARNING: Variable DTE already exists on file PERM.MERGEDTEMP22. WARNING: Variable OCFA already exists on file PERM.MERGEDTEMP22. WARNING: Variable TACC already exists on file PERM.MERGEDTEMP22. WARNING: Variable MVE already exists on file PERM.MERGEDTEMP22. WARNING: Variable BTM already exists on file PERM.MERGEDTEMP22. NOTE: Table PERM.MERGEDTEMP22 created, with 1 rows and 23 columns. 1169 quit; NOTE: PROCEDURE SQL used (Total process time): real time 2.73 seconds cpu time 0.12 seconds I get this log output when I run: proc sql; create table perm.Mergedtemp22 as select a.*, b.conm, b.ipodate, b.cik,b.roa, b.LnAT, b.turn, b.DTE,b.OCFA, b.TACC,b.MVE,b.BTM from perm.Mergedtemp21 as a left join perm.compustatnew4 as b on a.gvkey2=b.gvkey and a.year eq b.year and a.calendarquarter eq b.calendarquarter order by permno, mergerdateannounced; quit;
... View more