topic Re: Array in SAS Programming

Array

POOJA_J — Tue, 31 Oct 2023 12:16:26 GMT

Write a SAS program that will:
• Create output data set work.ACT01 using sashelp.pricedata as input.
• Use an array to increase the values of the price1 through price17 variables by 10%.

How to solve this?

Re: Array

PaigeMiller — Tue, 31 Oct 2023 12:18:52 GMT

We don't usually do your homework for you. However, if you give it a try and can't seem to get it to work, show us your code and we will be happy to help.

Re: Array

ballardw — Tue, 31 Oct 2023 14:51:03 GMT

Here's a start. Fill it what you have attempted for the array and calculations.

data work.ACT01;
   set sashelp.pricedata;
run;

Re: Array

Reeza — Tue, 31 Oct 2023 14:54:29 GMT

@POOJA_J wrote:

Write a SAS program that will:
• Create output data set work.ACT01 using sashelp.pricedata as input.
• Use an array to increase the values of the price1 through price17 variables by 10%.

How to solve this?

Here's a tutorial on using Arrays in SAS
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

See the example under "Computing new variables", though make sure you double check your answer.

Re: Array

Kurt_Bremser — Tue, 31 Oct 2023 16:21:52 GMT

More important sources of knowledge (Maxim 1!):

ARRAY Statement

Array Reference

Re: Array

POOJA_J — Wed, 01 Nov 2023 03:44:51 GMT

This is what I tried. But I'm stuck on adding the value to original price after doing the percent.

data work.ACT01;
set sashelp.pricedata;
array Prices(12)price1--price12;
do i=1 to 12;
prices(i)=prices(i) * (10/100);
end;
run;

Re: Array

Kurt_Bremser — Wed, 01 Nov 2023 06:14:19 GMT

One percent is 0.01 of the original value. 10 percent are 0.1 of the original value. To add 10 percent, you have to multiply the original value by 0.1, and add that to the original value.

x = x + x * 0.1;

or, simplified

x = x * 1.1;