Help using Base SAS procedures

SAS Product Function

Reply
N/A
Posts: 0

SAS Product Function

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!
Respected Advisor
Posts: 3,890

Re: SAS Product Function

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 Smiley TonguerodList 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;
Ask a Question
Discussion stats
  • 1 reply
  • 715 views
  • 0 likes
  • 2 in conversation