How to use Macro to create variables

[AmyH_01]

Hi, 

I am not familiar with using Macro, but I think macro can really help to generate powerful code in my scenario.

So, I have variable X1_1 to X10_1, each of them has its match Y1_1 to Y10_1. I want to create MI=1 if the condition is matched. 

DATA file;

set file;

IF X1_1 in (1:3)  & Y1_1>=70 & Y1_1<=100 then MI=1;

IF X2_1 in (1:3)  & Y2_1>=70 & Y2_1<=100 then MI=1;

...

IF X10_1 in (1:3)  & Y10_1>=70 & Y10_1<=100 then MI=1;

run;

I wonder if anyone here can help me to use Macro to create my codes. Thank you so much.

[Reeza · Accepted solution]

You do not need a macro here, you need an array. 

Here's a tutorial on using Arrays in SAS
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

DATA file;
set file;

array x(*) x1_1--x10_1;*assumes variables are in order;
array y(*) y1_1 --y10_1;*assumes variables are in order;

*set to missing;
M1 = .;

do i=1 to 10 while(M1 ne 1);
      if x(i) in (1:3) and y(i) >=70 and y(i) <= 100 then M1 =1;
end;

run;

---

@AmyH_01 wrote:

Hi, 

I am not familiar with using Macro, but I think macro can really help to generate powerful code in my scenario.

So, I have variable X1_1 to X10_1, each of them has its match Y1_1 to Y10_1. I want to create MI=1 if the condition is matched. 

DATA file;

set file;

IF X1_1 in (1:3)  & Y1_1>=70 & Y1_1<=100 then MI=1;

IF X2_1 in (1:3)  & Y2_1>=70 & Y2_1<=100 then MI=1;

...

IF X10_1 in (1:3)  & Y10_1>=70 & Y10_1<=100 then MI=1;

run;

I wonder if anyone here can help me to use Macro to create my codes. Thank you so much.

---

[ketpt42]

I have just been @Reeza'd. Too fast.

[AmyH_01]

Thank you so much, Reeza! I was doing the array at first but I forgot to put while (MI ne 1), that caused the result became a mess. Thank you so much for your great help!! I truly appreciate it!