re: Column Product

twildone — Thu, 20 Apr 2017 14:29:05 GMT

Hi, I would like to multiply the entries in a column similar to the product function in excel. That is, I have the number of claims for there respective fiscal year and would like to mutliply the changes between the fiscal years as in the column Change below. Each year I add new information to the dataset so that the number of fiscal years will change. Any suggestion on how I can do this....thanks

Have:

FiscalYear	Claims	Change
2007-2008	1168719
2008-2009	1249323	1.068968
2009-2010	1295424	1.036901
2010-2011	1346699	1.039582
2011-2012	1392185	1.033776
2012-2013	1504159	1.08043
2013-2014	1642564	1.092015
2014-2015	1955435	1.190477
2015-2016	2215927	1.133214
2016-2017	2352370	1.061574

Want:

Cum_Variance

2.012776

Re: re: Column Product

ballardw — Thu, 20 Apr 2017 15:02:09 GMT

I don't see any "product" involved. That looks like last claim/ first claim.

Is there supposed to be grouping variable involved such as a company name?

If so

proc sort data=have;
   by company fiscalyear;
run;

data want;
   set have;
   by company;
   retain firstclaim ;
   if first.company then firstclaim=claim;
   if last.company then do;
      cum_variance = claim/firstclaim;
      output;
   end;
run;

You should know by now how to post data as a datastep and to use the code boxes for posting code.

topic re: Column Product in SAS Programming

re: Column Product

Re: re: Column Product