topic Re: SCAN with a list of Full Names in SAS Programming

SCAN with a list of Full Names

waldo11 — Tue, 26 Nov 2019 00:03:56 GMT

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?

Re: SCAN with a list of Full Names

ballardw — Tue, 26 Nov 2019 00:37:40 GMT

1) The macro language has its own %scan function, so no need to us %sysfunc.

2) in general passing lists with comma's causes problems because the first comma encountered is going to be treated as a delimiter between successive parameters.

3) really not a good idea to have macro variables just appear in the middle of the code you should have a parameter for the list

%macro name_list (full_name_list);

4) And passing a parameter with embedded commas would require use of

%name_test( %str(HARRY LEVY, ABEL JAMES, ABHISHEK SINGH, ADAM LINKS) );

5) No particular nasty code needed:

%let list=HARRY LEVY, ABEL JAMES, ABHISHEK SINGH, ADAM LINKS;

%let lastthird= %scan("&list",6);
%put &lastthird;

Normally I would not put the &list in quotes but the comma's are also an issue for any macro function.

Re: SCAN with a list of Full Names

Tom — Tue, 26 Nov 2019 01:32:52 GMT

You tried to execute this mess:

%let full_name_list=%sysfunc(scan(HARRY LEVY, ABEL JAMES, ABHISHEK SINGH, ADAM LINKS,1,','));

So SAS is complaining that you have given the SCAN() function 6 arguments. That function does not have 6 arguments.

If you have comma delimited list you will need to use macro quoting to protect the commas from becoming part of the command syntax. Also don't include quotes in the list of delimiters or else the SCAN(), or %SCAN(), function will use them as delimiters.

If you want to find an item in the list use something like this instead:

%let full_name=%scan(%superq(full_name_list),&ARRAY_COUNTER,%str(,));