Date:         Tue, 18 Jun 2002 22:17:38 -0700
Reply-To:     Stig Eide <stigeide@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stig Eide <stigeide@YAHOO.COM>
Organization: http://groups.google.com/
Subject:      Re: Cumulated multiplication ???
Content-Type: text/plain; charset=ISO-8859-1

I think this will do the job:
data cpinew;
  set cpiold;
  retain cpicum 1;
  cpicum=cpicum*cpi;
run;

Stig Eide
pawel.manowiecki@wp.pl (Pawel Manowiecki) wrote in message news:<5aaae195.0206181424.371ed53c@posting.google.com>...
> I have CPI (Consumer price index) series
> with the year before as a base.
> (change in prices from the preceeding year)
> for example :
> 1999 100
> 2000 101
> 2001  99
> 2002  85
> 2003 120
>
> And i want to translate it in cumulated series.
> CPI with a base period in 1999.
> So i have got to multiplicate 1-with-2, 1-with-2-with-3,
> and so on ...
> so it is :
> 1999 100
> 2000 101
> 2001  99,9
> 2002  84,9
> 2003 101,9
>
> How to do it in the simplest way in SAS ??
> (Not using ln aproximation :-) )
>
> Tnx,
>
> Pawel Manowiecki
> SAS Student
> pawel.manowiecki@wp.pl