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.
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.
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.
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;
Thanks Kurt and RW9.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.