SAS Product Function

deleted_user — Mon, 05 Apr 2010 19:46:17 GMT

I need calculate the product of a series of variables, for instance: var1 var2 ... var100, I need the product of var1-var100, instead of var1*var2*...*var100, is there a simple way to calculate that result?

I assume there should be some fuction to do that, just like the sum of var1-var100 could be done by sum(of var1-var100). I check function product but it doesn't seem the right way.

Greatly appreciate any suggestions and help!

Re: SAS Product Function

Patrick — Tue, 06 Apr 2010 10:08:12 GMT

There is no product function as much as I know.

Some code like below might help:

data have;
var1=5; var2=3;
run;

%let prodlist=;
proc sql noprint;
select name into :ProdList separated by '*'
from dictionary.columns
where libname='WORK' and memname='TEST' and upcase(name) like 'VAR%'
;
quit;

data want;
set have;
product=&prodlist;
put product=;
run;

topic SAS Product Function in SAS Procedures

SAS Product Function

Re: SAS Product Function