Hi Experts,   I would like to create a macro drop-list after the formatlist macro.   The new macro droplist could be used in the data steps for the further procedure. I use Proc SQL to generate a one, but log window showed an error message.  Please advice how to fix it, thanks. %macro Answer(formatlist =); %let FormatCNT=%sysfunc(countw(&FormatList)); %do JJ = 1 %to &FormatCNT; %let Format=%scan(&FormatList,&JJ); proc sql; select distinct &Format. from test; quit; %end; %mend; %Answer(formatlist= A B C D E); proc sql noprint; select Name into : droplist separated by ' ' from test where Name in ('&formatlist.'); quit; %put &droplist; data want; set test; if PUI_Access_Table not in ('&droplist.'); run; ... View more

Hello experts,   I would like to change the text into number format in several variables.  However, I found out the text format coming so many different ways.  For example, the positive answer is 'Yes', 'Y','y', 'YES', 'yes'.   My current coding couldn't cover all of the requirement.   Any idea how to fix it?  Thanks. data want (drop = A B C D E); set have; array Old (*) A B C D E; array New (*) AA BB CC DD EE; do i = 1 to dim(Old); if Old(i) in ('No', 'n') then New(i)=0; else if Old(i) in ('Yes', 'y') then New(i)=1; else if Old(i) in ('Unknown') then New(i)=9; end; run; ... View more