Thanks very much ! I simplified it a bit to meet my needs : %let vars1 = Id Germ Gender PostCode DateOfDiagnosis DateOfBirth; data test; stop; length &vars1 $3; run; proc transpose data=test(obs=0) out=vars; var _all_; run; proc sql noprint; select quote(strip(_name_)), quote(cats('_',_name_)), catx('=_',_name_,_name_) into :vars2 separated by ',', :vars3 separated by ',', :vars4 separated by ' ' from vars; quit; run; %_eg_conditional_dropds(test, vars); %put &vars1; %put &vars2; %put &vars3; %put &vars4;
... View more