@Patrick Thank you. I was able to use this logic and apply my code to all datasets. It works great. Thanks very much for the assistance.
Posting the code here for reference:
/*Dropping all date variables*/ /* define parameters */ %let libref=temp; %let col_pattern=DTC;
/* use call execute to drop a list of columns dynamically populated into SAS variable DropList */ data _null_; set sashelp.vcolumn(keep=libname memname name where=(libname=%upcase("&libref") and find(name,"&col_pattern",'i')>0)); by libname memname; length DropList $32767; retain DropList; DropList=catx(',',DropList,name); if last.memname then do; call execute(catx(' ', 'proc sql; alter table', cats(libname,'.',memname),'drop', DropList, ';quit;')); call missing(DropList); end; run;
... View more