topic Scan function in MACRO in SAS Programming

Scan function in MACRO

robertrao — Mon, 22 Oct 2012 22:56:28 GMT

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 — Mon, 22 Oct 2012 22:59:34 GMT

SCAN is a SAS function

%SCAN is a SAS MACRO

And not all functions work with sysfunc, read the documentation

Linlin — Mon, 22 Oct 2012 23:07:59 GMT

you could if you want to:

%let varnames= Apple ball cat orange;

%let i=1 ;

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

%put &thisvar;

robertrao — Mon, 22 Oct 2012 23:14:31 GMT

Yeah,

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

Thanks