CB, I would merge by filenum, renaming one set of variables: DATA TOGETHER; MERGE OLDDATA(KEEP=FILENUM ASSET LIAB) NEWDATA(KEEP=FILENUM ASSET LIAB RENAME=(ASSET=NEWASSET LIAB=NEWLIAB)); BY FILENUM; ... RUN;

Tim Berryhill - Contract Programmer and General Wizard TWB2@PGE.COM or http://www.aartwolf.com/twb.html Frequently at Pacific Gas & Electric Co., San Francisco The correlation coefficient between their views and my postings is slightly less than 0

> ---------- > From: Cybie Frontier[SMTP:cybie@HOTMAIL.COM] > Reply To: Cybie Frontier > Sent: Tuesday, May 26, 1998 2:55 PM > To: SAS-L@UGA.CC.UGA.EDU > Subject: Simple data manipulation Question > > Hi Folks: > > I have this data manipulation question. There are 4 vars and 2 obs > ineach dataset. Obviously they are test data sets. > > > > year filenum asset liab; > > 1979 100 50 100 > 1979 200 150 200 > > > year filenum asset liab > 1980 100 200 300 > 1980 200 200 400 > > > > This is what I want to do: > > Create a new dataset with two variables that calculate the percentage > change of asset and liability from 1979 to 1980. > > This is how it should look like: > > Title: Percentage changes of assets and liabilitues > > Filenum Delasset Delliab > > 100 300 200 > 200 33.33 100 > > Formula used: (1980 is the new value and 1979 is the old value) > percentage change = ((new value-old value)/old value) * 100 > > Any help is highly appreciated. > > Thanks > > CF > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com >