Scan function in MACRO

[robertrao]

Hi Team,

Recently I learnt that whenever we are refwerring to SAS functions in MAcros we have to use %sysfunc.

In this piece of code ISNT SCAN a SAS function? Don t we need to use %sysfunc before the SCAN.

%macro  dothis;

%let varnames= Apple ball cat orange;

ods pdf file='myfilename';

%do i=1 %to %sysfunc(countw(&varnames));

%let thisvar=%scan(&varnames,&i, &str());

Regards

[Reeza]

SCAN is a SAS function

%SCAN is a SAS MACRO

And not all functions work with sysfunc, read the documentation

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

[Linlin · Accepted solution]

you could if you want to:

%let varnames= Apple ball cat orange;

%let i=1 ;

%let thisvar=%sysfunc(scan(&varnames,&i));

%put &thisvar;

[robertrao]

Yeah,

It works well. So %scan is an inbuilt MAcro function as Reeza was explaining?????

Thanks