topic Is there any multiplication function (∏) in sas? in SAS Procedures

Is there any multiplication function (∏) in sas?

iusing — Fri, 18 Nov 2011 17:36:34 GMT

As the title, what is the sas function of ∏?

Re: Is there any multiplication function (∏) in sas?

FriedEgg — Fri, 18 Nov 2011 18:16:04 GMT

Could you provide more information as to what extactly you have and are trying to accomplish...

∏		product product over … from … to … of arithmetic	means a₁a₂···a_n.	= (1+2)(2+2)(3+2)(4+2) = 3 × 4 × 5 × 6 = 360
∏		Cartesian product the Cartesian product of; the direct product of set theory	means the set of all (n+1)-tuples (y₀, …, y_n).

SAS Product Function (part of SAS/IML):

http://support.sas.com/documentation/cdl/en/imlug/59656/HTML/default/viewer.htm#langref_sect206.htm

For base SAS you can refence this previous post:

http://communities.sas.com/thread/9269

Is there any multiplication function (∏) in sas?

art297 — Fri, 18 Nov 2011 18:18:53 GMT

I'm not familiar with SAS having a multiplication function, unless you are actually referring to a factorial (i.e., !) for which there is the fact() function. Of course, you could always roll your own, e.g.:

data want;

input x1-x6;

array nums(*) x1-x6;

mult=nums(1);

do i=2 to dim(nums);

mult=mult*(1+(nums(1)/nums(i)));

end;

cards;

1 2 3 4 5 6

;

Is there any multiplication function (∏) in sas?

iusing — Fri, 18 Nov 2011 18:47:51 GMT

What I am looking for is the ak one. Multiplying different number

Is there any multiplication function (∏) in sas?

Tom — Fri, 18 Nov 2011 18:54:39 GMT

Why not use the GEOMEAN function and then convert it to the product using power operator?

product = geomean(of x1-x3) ** n(of x1-x3);

Is there any multiplication function (∏) in sas?

FriedEgg — Fri, 18 Nov 2011 19:31:55 GMT

proc fcmp outlib=work.funcs.math;

function capital_pi(nums

) varargs;

mult=nums[1];

do i=2 to dim(nums);

mult=mult*(1+(1/nums));

end;

return(mult);

endsub;

test=capital_pi(1,2,3,4,5,6);

put test=;

run;

%let cmplib=%sysfunc(getoption(cmplib));

options cmplib=(work.funcs);

data _null_;

input x1-x6;

array x[6];

array nums[6] _temporary_; *Array parameters to subroutine calls must betemporary arrays.;

do i=1 to 6;

nums=x;

end;

product=capital_pi(nums);

put product=;

cards;

1 2 3 4 5 6

;

run;

options cmplib=&cmplib;

Result is 3.5

Is there any multiplication function (∏) in sas?

Howles — Fri, 18 Nov 2011 20:27:55 GMT

See http://www.sascommunity.org/wiki/Computing_Products

iusing wrote:
As the title, what is the sas function of ∏?