topic Re: Array in a Do Loop in SAS Programming

Array in a Do Loop

Jodifer77 — Sat, 23 Mar 2019 22:24:37 GMT

Can someone help me understand how the code is processing the output in the attached table?

data number;
array member[*] mem1-mem12;
mem1=10;
do id=1 to dim(member)-3;
   member[id+1]=id/member[id];
   output;
   end;
run;

Re: Array in a Do Loop

justusjillella — Sat, 23 Mar 2019 23:15:56 GMT

Hi, dim(MEMBER) returns 12 as there are 12 elements in the array

The do loop resolves to
Id=1 to 9
During the first iteration
Mem(id+1) resolves to membe[2] which is nothing but mem2 variable
Mem2=1/10 and this variable is written to the output dataset

This step is iterated till member[9] which is mem9 variable according to the array

Re: Array in a Do Loop

Astounding — Sat, 23 Mar 2019 23:18:01 GMT

Give us somewhere to begin.

Do you know what the DATA statement does?

Do you know what the END statement does?

Do you know what the OUTPUT statement does?

Do you know what the ARRAY statement does?

Have you printed and examined the results?

Re: Array in a Do Loop

Jodifer77 — Sun, 24 Mar 2019 14:11:32 GMT

Thanks for the feedback! I didn't understand where the denominator was coming from, but I think I do now. The denominator is the result of the previous iteration's calculation, right?

Thanks!

Re: Array in a Do Loop

Jodifer77 — Sun, 24 Mar 2019 14:14:15 GMT

Thanks for you time in responding. It was my first question posted...

My question was in the iterative do loop, I didn't know where the denominator for the member[id+1]=id/member[id] was coming from. I was able to figure it out that it was the value calculated in the previous iteration. I think I'm good to go.

Thanks!