As @BrunoMueller mentioned, the key point is that multiple value prompts create multiple macro variables, not a single variable holding a list of values. I use a macro to create the list I want, something like: %macro ConcatenateSelectionList
(prompt
,dlm=%str( )
);
%local i return ;
%if &&&prompt._Count >= 2 %then %do i = 1 %to &&&prompt._Count ;
%if &i=1 %then %let return=&&&prompt&i ;
%else %let return=&return&dlm&&&prompt&i ;
%end ;
%else %if &&&prompt._Count = 1 %then %do ;
%let return=&&&prompt ;
%end ;
%else %if &&&prompt._Count = 0 %then %do ;
%let return= ; %*null ;
%end ;
%else %put ER%str()ROR: USER &=&prompt._Count;
&return
%mend ConcatenateSelectionList; I blogged about over at bi-notes.com: http://bi-notes.com/2013/08/sas-stored-process-taming-selection-list-prompts/
... View more
