I used your same code. In place of libname is used "E" instead of "WORK", for "HAVE" i used my file name "Comb_File_VTE_F". Looks like I made a mistake, when i ran the code I got the log output as "No rows selected". Can you point my mistake? Thanks proc sql noprint;
select catt(name,'_base=',name,';')
into : creates separated by ' '
from dictionary.columns
where libname= "E" and
memname='Comb_File_VTE_F'
;
quit;
data E.Comb_File_VTE_F1;
set E.Comb_File_VTE_F;
&creates.
run;
... View more
