topic Re: ARRAY,MACRO variable. (ERROR with missing suffix ) in SAS Programming

ARRAY,MACRO variable. (ERROR with missing suffix )

SMUGGLE — Wed, 10 Jan 2024 16:26:02 GMT

Good day to everyone.
Got some issue with...idk even what type of problem is...macro, arrays or even do loop.
%macro name(indata=, some_num=);
data &indata_new;

set &indata;

array var_x_arr [*] var_x1 - var_x&some_num.;
array var_y_arr [*] var1_y - var&some_num._y;
do j = 1 to dim(var_x_arr);
if var_y_arr (j) = "Y" then do;
col4 = var_x_arr(j);
end;
end;
run;
%mend;

%name(indata=A, some_num=2);
%name(indata=B, some_num=5);

So, the essence of my question is that I have 2 types of variables that are always together (var_x1 and var1_y)
In dataset A there are only 2 of them (that is, var_x1 var1_y and var_x2 var2_y)
In dataset B there are only 5 of them (that is, var_x1 - var_x5 and, accordingly, var1_y - var5_y)
var_x1 accepts text values
var2_y accepts either 'Y' or 'N'
But it gives an error "ERROR: Missing numeric suffix on a numbered variable list (var_x1 - var_x2)

already triing "
array var_x_arr [&some_num.] var_x1 - var_x&some_num.;
array var_y_arr [&some_num.] var1_y - var&some_num._y;
do j = 1 to &some_num.; "
and different variants writing with these syntax( with $ and without, " to dim()" and so on)

My version is 9.4

Re: ARRAY,MACRO variable. (ERROR with missing suffix )

Tom — Wed, 10 Jan 2024 17:03:17 GMT

You cannot make a variable list using syntax like:

var1_y - var5_y

The number must be at the END of the name.

The best thing would be to change your variable names. So something like:

var_y1 - var_y5

Otherwise you will need to use macro code to generate that goofy series of names.

array var_y_arr [*]  
%do i=1 to &some_num;
  var&i._y 
%end;
;

So that you get this SAS code generated.

array var_y_arr [*] var1_y var2_y var3_y var4_y var5_y ;

Re: ARRAY,MACRO variable. (ERROR with missing suffix )

PaigeMiller — Wed, 10 Jan 2024 16:34:57 GMT

Turn on the macro debugging tools by running this command

options mprint;

then run your macro again and show us the ENTIRE log (that's every single line, every single character, do NOT select just the error messages). Include the log in the window that appears when you click on the </> Icon. DO NOT SKIP THIS STEP.

Re: ARRAY,MACRO variable. (ERROR with missing suffix )

SMUGGLE — Wed, 10 Jan 2024 17:01:37 GMT

"The number must at the END of the name" 🤦🤦🤦
EXACTLY
How could I forget about this.
Thanks a lot!)

Re: ARRAY,MACRO variable. (ERROR with missing suffix )

SMUGGLE — Wed, 10 Jan 2024 17:05:39 GMT

It's already been done.

and i'm grateful for your attention to my question.
The main problem was in array variables name