topic how can I use an array dimension in a macro? in SAS Procedures

how can I use an array dimension in a macro?

hyqwel — Tue, 02 Feb 2010 14:26:47 GMT

%macro aaaa();
data a;
array new{4} score1-score4;
%do i=1 %to dim(new) %by 1;
new{i}=10;
%end;

proc print data=a;
run;
%mend aaaa;
%aaaa();

log window:
MPRINT(AAAA): array new{4} score1-score4;
ERROR: Required operator not found in expression: dim(new)
ERROR: The %TO value of the %DO I loop is invalid.
ERROR: The macro AAAA will stop executing.

Re: how can I use an array dimension in a macro?

sbb — Tue, 02 Feb 2010 15:27:01 GMT

Suggest you use a macro variable declared with a %LET statement to identify the maximum array element/variable.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument this topic/post:

using macro variables site:sas.com

Re: how can I use an array dimension in a macro?

RickM — Tue, 02 Feb 2010 15:28:26 GMT

I could be wrong but I think you want to use the regular data step do loop instead of %do. %Do is something you should use if you want to iterate blocks of code such as series of data steps or procs. I dont think %do can access the array in the data step.

Re: how can I use an array dimension in a macro?

hyqwel — Tue, 02 Feb 2010 16:09:14 GMT

You are right. Thanks!