topic Nested do loop in sas in SAS Programming

Nested do loop in sas

subhasr — Mon, 23 Nov 2015 19:41:47 GMT

Hi,

I am new to SAS community. I have a small problem with do loops while using macro. I want to get Bill_1, bill_2 , bill_3 which is assigned as i (bill_&i). I also want stat_1, stat_2 and stat_3 which is assigned as j (stat_&j).

Now I write a do loop for %do i= 1 %to 3;
%do j= 1 %to 3;

So definitely its getting looped 9 times. But I want it to produce just 3 combinatuions like this. Bill_1,Stat_1

Bill_2,Stat_2

Bill_3,Stat_3.

If I could get some help please.

Re: Nested do loop in sas

Haikuo — Mon, 23 Nov 2015 19:54:48 GMT

Can you assign them using the same macro variable, say i and do one loop?

bill_&i, stat_&i

%do i= 1 %to 3

Re: Nested do loop in sas

subhasr — Mon, 23 Nov 2015 21:19:34 GMT

Yipeeeeeee it worked. Thanks a lot Haikuo.

Re: Nested do loop in sas

kannand — Tue, 24 Nov 2015 03:03:03 GMT

Please accept @Haikuo's solution so you give "he or she" the credit and remove this problem from the pending queue. Of course when time permits.

By the way, welcome to the forum...!!!