proc sql;
select distinct name into :names separated by ' ' from dictionary.columns where upcase(memname)='HAVE' and upcase(libname)='WORK' and upcase(name)?'JAN';
quit;
data want; set have (drop=&names); /* OR set have (keep=&names); */ run;
-- Paige Miller
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.