If I setup key=Maker Model, and try to use the answer from my other post, change it to 'Maker', 'Model' and then pass it through this code chunk, it did not work. So I think maybe I need to simply the process: instead of adding a step to make "key=Maker Model" fit, I can set it up as "Key="Marker', 'Model'". But somehow it did not work.😅
If I bind those two together , I can have following codes but it is not working. Not sure how to fix it:
%macro m_test(varlst=);
%let key=%str(%')%qsysfunc(tranwrd(&varlst.,%str( ),%str(%', %')))%str(%');
data test;
declare hash found_keys();
found_keys.definekey(&key.);
found_keys.definedone();
do while (not done);
set sashelp.cars end=done;
rc=found_keys.add();
output;
end;
stop;
run;
%mend;
%m_test(varlst=Make Model);
... View more