topic Re: SAS macro question in SAS Programming

SAS macro question

Niugg2010 — Fri, 09 Nov 2018 17:18:13 GMT

Below is my macro:

%macro try(dsns=);

%let dsnnum=%sysfunc(countw("&dsns.", ' ,;:'));

%put &dsnnum.;

%do k=1 %to &dsnnum.

%let dsn=%scan(&dsns., &k., %str( ,));

%put &dsn.;

%end;

%mend ;

%try(dsns=%str(aaa, bbb, ccc))

For the first loop, I want it &dsn=aaa, second loop &dsn=bbb, third loop &dsn=ccc;

when I run above code, it produces some errors:

WARNING: Apparent symbolic reference K not resolved.

ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric

operand is required. The condition was: &k.

ERROR: Argument 2 to macro function %SCAN is not a number.

Someone can help me out?

Thanks

George

Re: SAS macro question

Tom — Fri, 09 Nov 2018 17:27:53 GMT

Your first %LET statement has what appear to be unbalanced quotes. Why are you using quotes anyway?

Why are you making your task harder by adding commas in the value you are passing to macro?

If it is a list of dataset names then just use spaces between the names.

%macro try(dsns);
  %local dsnnum k dsn;
  %let dsnnum=%sysfunc(countw(&dsns,%str( )));
  %put &=dsnnum ;
  %do k=1 %to &dsnnum ;
    %let dsn=%scan(&dsns., &k., %str( ));
    %put &=k &=dsn;
  %end;
%mend try ;

%try(dsns=aaa bbb ccc)

Re: SAS macro question

FreelanceReinh — Fri, 09 Nov 2018 17:31:00 GMT

Hi @Niugg2010,

Adding the missing semicolon after

%do k=1 %to &dsnnum.

would help a lot.

Re: SAS macro question

Niugg2010 — Fri, 09 Nov 2018 17:56:02 GMT

Got it. Thanks