DATA Step, Macro, Functions and more

beginner question on Array

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

beginner question on Array

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.


Accepted Solutions
Solution
‎05-10-2017 01:00 AM
Super User
Posts: 6,938

Re: beginner question on Array

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎05-10-2017 01:00 AM
Super User
Posts: 6,938

Re: beginner question on Array

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,401

Re: beginner question on Array

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;
Occasional Contributor
Posts: 10

Re: beginner question on Array

Thanks Kurt and RW9.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 124 views
  • 0 likes
  • 3 in conversation