Date: Tue, 26 May 1998 14:55:55 PDT
Reply-To: Cybie Frontier <cybie@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Cybie Frontier <cybie@HOTMAIL.COM>
Subject: Simple data manipulation Question
Content-Type: text/plain
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
