I will compare the processing time of using nested do loops with the findw-index method. I have to loop through 100 variables and compare with 4000 new variable names on about 10,000 records. do v=1 to dim(var); out{findw("&vlist",trim(var{v}),' ','E')}=val{v}; end; Can the proc sql statement be adapted to 100 variables (Var1-Var100) and also add a character prefix to each distinct value? The values in Var1-Var100 are all numerals and need a character prefix to confirm to SAS variable name rules. Given your reccomended approach, I assume that, Call Execute can not return sas datastep code with the new variable names and values to the 'Calling' datastep. It appears that Call Execute can return sas datasetep code to a spawned datasetp. Thanks for your help.
... View more