I want a scan function within a macro that can pull last name of the third person in a list. Example: %put &full_name_list. HARRY LEVY, ABEL JAMES, ABHISHEK SINGH, ADAM LINKS %macro name_test(); %do array_counter = 1 %to &name_count.; %let full_name = %SYSFUNC(SCAN(&FULL_NAME_LIST, &ARRAY_COUNTER, ',')); %end; %mend; %name_test(); I get the following error when I run this: NOTE: One or more missing close parentheses have been supplied for the %SCAN function. ERROR: Expected close parenthesis after macro function invocation not found. When I have a list of one name (either first or last) then this works perfectly. But I want to be able to pull the full name out. Any ideas?
... View more