topic Re: how to use array function to perform arithmetic calculation repeatedly on the same dataset in New SAS User

how to use array function to perform arithmetic calculation repeatedly on the same dataset

srikanthyadav44 — Mon, 12 Aug 2019 17:56:18 GMT

Dear all

Greetings of the day

i have to perform a arithmetical calculation repeated on the same dataset with the repeated variables from the year 2010 to 2018.

my data set is as follows

Var1_2010	var2_2010	var3_2010	Var1_2011	var2_2011	var3_2011	………….	Var1_2018	var2_2018	var3_2018
21.21	-1.4	-19.8	1.5	5.7	32.1		59.8	21.16	-8.9
5892.48	1807	245.7	824.6	158	7712.8		7617.3	5786.81	2025.8
107.71	-4.6	-18.5	1.2		-1.6		22.6	4.9	-5.9
206.18	35.6	1.5	79.9	19.5	1082		651.6	235.06	51.4
1080.4	-422.2	113.9	158.7	28.6	845.4		1885.2	1103.55	-755.9

I have to do the computation as follows

newvar_2010=var1_2010*0.345+var2_2010*0.657+var3*0.768

i have to repeat it for all the remaining years in the same way from 2011 to 2018.

please suggest me a SAS code to do the calculation as mentioned above.

thanks in advance.

Re: how to use array function to perform arithmetic calculation repeatedly on the same dataset

Reeza — Mon, 12 Aug 2019 18:14:49 GMT

Same answer as your other question really, use an array to loop.

https://stats.idre.ucla.edu/sas/seminars/sas-arrays/arrays-in-sas/

Re: how to use array function to perform arithmetic calculation repeatedly on the same dataset

novinosrin — Mon, 12 Aug 2019 18:18:45 GMT

Untested coz I was lazy to create sample data


data want;
 set have;
 array _constant(3) _temporary_ (0.345,0.657,0.768) ;
 array new(2010:2018) new2010-new2018;
 array t(2010:2018,3) var1_2010--var3_2018;
 do _i=2010 to 2018;
  do _j=1 to 3;
   new(_i)=sum(t(_i,_j)*_constant(_j),new(_i));
  end;
 end;
 drop _:;
run;

Re: how to use array function to perform arithmetic calculation repeatedly on the same dataset

PaigeMiller — Mon, 12 Aug 2019 19:39:40 GMT

@srikanthyadav44 wrote:

Dear all

Greetings of the day

i have to perform a arithmetical calculation repeated on the same dataset with the repeated variables from the year 2010 to 2018.

my data set is as follows

Var1_2010 var2_2010 var3_2010 Var1_2011 var2_2011 var3_2011 …………. Var1_2018 var2_2018 var3_2018

21.21 -1.4 -19.8 1.5 5.7 32.1 59.8 21.16 -8.9

5892.48 1807 245.7 824.6 158 7712.8 7617.3 5786.81 2025.8

107.71 -4.6 -18.5 1.2 -1.6 22.6 4.9 -5.9

206.18 35.6 1.5 79.9 19.5 1082 651.6 235.06 51.4

1080.4 -422.2 113.9 158.7 28.6 845.4 1885.2 1103.55 -755.9

Adding to the other replies ... this data structure is not a good one for most types of analyses, if you have created this data structure, the next time you might want to make it look like this:

Row VAR YEAR Value

1 var1 2010 21.21

1 var2 2010 -1.4

1 var3 2010 -19.8

2 var1 2010 5892.48

etc.

and the whole analysis of computing sums is extremely simple in PROC SUMMARY.

I realize that many times our data comes from Excel, and there it is organized as you showed in your original post, but if you are creating this data yourself, don't do it as in the original post, do it as I showed in this post.