topic Re: using the array to find averages of any two numbers from a set of numbers in SAS Programming

using the array to find averages of any two numbers from a set of numbers

Amy0223 — Wed, 04 Dec 2019 06:21:26 GMT

Hi, I'm not sure how to code the problem below. Your kind help is greatly appreciated!

Given the set of numbers: 11, 23, 17, 39, 50, using the array to find averages of any two numbers from a set of numbers. The two numbers can be the same.

Re: using the array to find averages of any two numbers from a set of numbers

Kurt_Bremser — Wed, 04 Dec 2019 06:42:58 GMT

Use two nested do loops (assuming n to be the number of elements): one counts index1 from 1 to n-1, and the inner loop from index1+1 to n. Build the average of array{index1} and array{index2}.

Re: using the array to find averages of any two numbers from a set of numbers

ed_sas_member — Wed, 04 Dec 2019 12:38:46 GMT

Hi @Amy0223

Does the following code answer your question?

Best,

data want;
	array number(5) (11 23 17 39 50);
	do i=1 to dim(number);
		do j=i to dim(number);
			couple_1 = number(i);
			couple_2 = number(j);
			average = mean(number(i),number(j));
			output;
		end;
	end;
	keep couple_1 couple_2 average;
run;

Re: using the array to find averages of any two numbers from a set of numbers

yabwon — Wed, 04 Dec 2019 12:33:48 GMT

Hi @Amy0223 ,

As @Kurt_Bremser wrote do it with double loop.

I'm not sure what do you mean by "The two numbers can be the same.", is it that you want also pair of (first,first), (second,second), (third, third) etc. or that just values can repeat? If you mean first option then change `next` macrovariable to 0.

%let next = 1;

data want;
  array A[5] _temporary_ (11, 23, 17, 39, 50);

  do i = 1 to dim(a);
    do j = i + &next. to dim(a);
      first  = a[i];
      second = a[j];
      avg = mean(first, second);
      output;
    end;
  end;
  drop i j;
run;

All the bets

Bart

Re: using the array to find averages of any two numbers from a set of numbers

Amy0223 — Wed, 04 Dec 2019 16:53:31 GMT

Wonderful! This is exactly what I've been looking for. Thank you so much for helping me!! I greatly appreciate your help!

Re: using the array to find averages of any two numbers from a set of numbers

Amy0223 — Wed, 04 Dec 2019 16:54:16 GMT

Thank you so much!! I greatly appreciate your help!

Re: using the array to find averages of any two numbers from a set of numbers

ed_sas_member — Wed, 04 Dec 2019 17:37:37 GMT

Thank you @Amy0223 !