topic Re: beginner question on Array in SAS Programming

beginner question on Array

thenewlearner — Tue, 09 May 2017 08:51:24 GMT

Hi everyone,

New learner on SAS, now onto the array. doing practice from the base certification disc on chapter 16. Here's a question about array:

the following codes seem to extract just the numeric values in the original data set and do calculations (staff donation * 1.25 = company+staff= total contribution), i want to do some adjustments so i can show: 1. staff contribution (the original value), company contribution (original *0.25) and the total ( 1.25);

not quite sure how i can array it and show them all in one table.

this is the practice code:

data sasuser.added(drop=i);
   set sasuser.funddrive;
   array contrib{4} qtr1-qtr4;
   do i=1 to 4;
      contrib{i}=contrib{i}*1.25;
   end;
run;
proc print data=sasuser.added;
run;

Thank you all.

Re: beginner question on Array

Kurt_Bremser — Tue, 09 May 2017 08:59:14 GMT

You can use the array statement to create new variables:

data sasuser.added(drop=i);
set sasuser.funddrive;
array contrib{4} qtr1-qtr4;
array comp_contrib{4} c_qtr1-c_qtr4;
do i=1 to 4;
  comp_contrib{i} = contrib{i} * 0.25;
end;
run;

I leave it to you how you add the third array and do the calculation for that.

Re: beginner question on Array

RW9 — Tue, 09 May 2017 08:59:29 GMT

Not quite following, but at a guess I would say you just need to further arrays:

data sasuser.added (drop=i);
   set sasuser.funddrive;
   array contrib{4} qtr1-qtr4;
   array staff_contrib{4};
   array comp_contrib{4};
   array total{4};
   do i=1 to 4;
      contrib{i}=contrib{i}*1.25;
      staff_contrib{i}=contrib{i};
      comp_contrib{i}=contrib{i}*0.25;
      total{i}=1.25;
   end;
run;

Re: beginner question on Array

thenewlearner — Wed, 10 May 2017 05:01:35 GMT

Thanks Kurt and RW9.