there is no results produced for this sql step proc sql; create table colsToMask as select c.libname, c.memname, c.name, c.type, c.length as len from ( select upcase(scan(cats('WORK.',dsname),-2,'.')) as libname length=8, upcase(scan(dsname,-1,'.')) as memname length=32, upcase(colname) as name length=32 from excel ) e , dictionary.columns c where e.libname=c.libname and e.memname=c.memname and e.name=upcase(c.name) and c.memtype='DATA' order by c.libname, c.memname ; quit; five columns are created like libname,memname,name,type,len but no entries are there.. can you please check this?
... View more