thank you for your logic. bit I have modified its working. but I want one more column which variable is getting output. for example: if variable is 'C' or 'D' or 'E' then colmn C D E modified prog: data _null_; set sashelp.vcolumn (where=(libname="WORK" and name in ("C","D","E")) end=last; if _n_=1 then call execute('data want; set '); call execute(cat('libA.',memname,' (keep=a b ',name, 'rename =(',name, '= col1) where=(not missing(',name,'))) ')); if last then call execute(';run;'); run; I am getting error when I am trying to include: call execute('; colmn = ' || name ); ERROR: data step component object failure.
... View more