topic Multiply columns starting similar in SAS Programming

Multiply columns starting similar

miner_girl — Mon, 13 Jul 2020 17:48:37 GMT

Dear SAS community,

I need a help regarding multiplication of more than 100 columns, all columns have name starting with pos_. I want to multiply all these columns with two other columns. I've tried this.

data want;
set have;
pos:=faktor*kurs*pos:;
run;

It want work. Any suggestion?

Thank you!

Re: Multiply columns starting similar

PaigeMiller — Mon, 13 Jul 2020 17:57:20 GMT

You could use an ARRAY

data want;
    set have;
    array p(*) pos:;
    do i=1 to dim(p);
        p(i)=faktor*kurs*p(i);
    end;
    drop i;
run;

Re: Multiply columns starting similar

Reeza — Mon, 13 Jul 2020 19:06:07 GMT

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