beginner question on Array

Solved
Occasional Contributor
Posts: 10

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: 10,534

Re: beginner question on Array

Posted in reply to thenewlearner

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
How to convert datasets to data steps
How to post code

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

Re: beginner question on Array

Posted in reply to thenewlearner

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
How to convert datasets to data steps
How to post code
Super User
Posts: 9,813

Re: beginner question on Array

Posted in reply to thenewlearner

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

Posted in reply to thenewlearner

Thanks Kurt and RW9.

☑ This topic is solved.

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

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