Question about Multi-Array

VVill — Tue, 19 Aug 2014 18:18:09 GMT

Hi all,

I have a question about arrays.

I have a data set that looks similar to this only much bigger (1000x) I need to calculate the combine scores of [a, b ,c ....n] based on a set equation [ ((n)x + (n)y) - Fixed]. I have created an array for it but I failed to obtain the answer:

The dummy data and the ideal outcome:

Data have							Ideal
Fixed	ax	ay	bx	by	cx	cy	a	b	c
6	13	21	12	16	11	10	28	22	15
13	14	21	15	10	15	10	22	12	12
1	16	11	20	19	15	15	26	38	29
10	14	14	18	17	17	17	18	25	24
16	10	14	10	13	12	21	8	7	17
17	19	16	17	11	13	20	18	11	16
7	11	12	15	19	21	20	16	27	34
2	16	21	17	11	15	14	35	26	27
11	20	17	17	14	12	20	26	20	21
19	12	11	10	17	11	21	4	8	13
6	12	20	10	12	17	13	26	16	24

The code:

data have;

input Fixed ax ay bx by cx cy;

datalines;

6 13 21 12 16 11 10

13 14 21 15 10 15 10

1 16 11 20 19 15 15

10 14 14 18 17 17 17

16 10 14 10 13 12 21

17 19 16 17 11 13 20

7 11 12 15 19 21 20

2 16 21 17 11 15 14

11 20 17 17 14 12 20

19 12 11 10 17 11 21

6 12 20 10 12 17 13

;

run;

data want;

set have;

array xcal (*) ax bx cx;

array ycal (*) ay by cy;

array wnt (*) a b c;

do i=1 to dim(xcal);

do j=1 to dim(ycal);

do k=1 to dim(wnt);

wnt(k) = (xcal(i) + ycal(j)) - fixed ;

end;end;end;

drop i j k;

run;

and the wrong outcome:

Fixed	ax	ay	bx	by	cx	cy	a	b	c
6	13	21	12	16	11	10	15	15	15
13	14	21	15	10	15	10	12	12	12
1	16	11	20	19	15	15	29	29	29
10	14	14	18	17	17	17	24	24	24
16	10	14	10	13	12	21	17	17	17
17	19	16	17	11	13	20	16	16	16
7	11	12	15	19	21	20	34	34	34
2	16	21	17	11	15	14	27	27	27
11	20	17	17	14	12	20	21	21	21
19	12	11	10	17	11	21	13	13	13
6	12	20	10	12	17	13	24	24	24

Could anyone advice me the right method or find out what is wrong with my code please?

Many thanks in advance!

Will

Re: Question about Multi-Array

data_null__ — Tue, 19 Aug 2014 18:53:23 GMT

You just have too many DOs.

data want;
   set have;
   array xcal ax bx cx;
   array ycal ay by cy;
   array wnt  a b c;
   do i=1 to dim(xcal);
      wnt = (xcal + ycal) - fixed ;
      end; 
   drop i;
   run;

Re: Question about Multi-Array

stat_sas — Tue, 19 Aug 2014 18:54:38 GMT

Hi,

I think only one do loop will do the job.

data want;
set have;
array xcal (*) ax bx cx;
array ycal (*) ay by cy;
array wnt (*) a b c;
do i=1 to dim(xcal);
wnt(i) = (xcal(i) + ycal(i)) - fixed ;
end;
drop i;
run;

proc print data=want;
run;

topic Question about Multi-Array in SAS Programming

Question about Multi-Array

Re: Question about Multi-Array

Re: Question about Multi-Array