topic anybody helps to explain what %let means here and the scan function in SAS Programming

anybody helps to explain what %let means here and the scan function

Bal23 — Tue, 26 Jul 2016 13:22:47 GMT

%macro uo;
%do i = 1 %to 9;
data a.nc;
%let setname = %scan(9 8 7 6 5 4 3 2 1, &i);
%if &i = 1 %then %do;
update a.data&setname  (keep = v1 v2)
       a.data10        (keep = v1 v2); 
%end;
%else %if &i > 1 %then %do;
update a.nc
	   a.data&setname (keep = v1 v2);
%end;
by v1;
run;
%end;
%mend;

%uo;

I am studying some sas programs and cannot understand the %let, %scan. Can anybody help to explain in details.

Thanks a lot

Re: anybody helps to explain what %let means here and the scan function

arodriguez — Tue, 26 Jul 2016 13:30:08 GMT

In macro language, %let is use to set the value of a variable into something.
For example,
%let i=1;
will set the macro variable i to 1, so when you write &i. will be replaced by 1.
%scan do the same that a scan function in a data step. In that case, select the &i word, separated by default separators.

Re: anybody helps to explain what %let means here and the scan function

rayIII — Tue, 26 Jul 2016 15:08:16 GMT

The SAS Macro Reference is a great resource for questions about specific statements and functions:

http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#a000543704.htm

http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/viewer.htm#z3514scan.htm

Re: anybody helps to explain what %let means here and the scan function

Tom — Tue, 26 Jul 2016 17:07:51 GMT

Looks like they want SETNAME to go from 9 down to 1. Instead of the using that strange %SCAN() funciton they could have just used arithmetic to convert I to SETNAME.

%let setname=%eval(10-&i);

They could have alos just use SETNAME in the %DO loop direcly.

%do setname = 9 %to 1 %by -1;
data a.nc;
%if &setname=9 %then %do;
update a.data&setname  (keep = v1 v2)
       a.data10        (keep = v1 v2); 
%end;
%else %do;
update a.nc
	   a.data&setname (keep = v1 v2);
%end;
by v1;
run;
%end;