topic Re: Can someone help me with create a new balance ? in SAS Procedures

Can someone help me with create a new balance ?

Anna_Guo — Wed, 19 Dec 2012 15:29:16 GMT

I am working on a bond project. Sometimes bond is called, I need to create a new bond face value for each year after being called. Below is a simple table:

Year	BondFV	Called	newFV
1	100	0	100
2	100	5	95
3	100	0	95
4	100	0	95
5	100	4	91
6	100	0	91

How can I create the last colume? (new FV)

Any help would be greatly appreciated!!

Re: Can someone help me with create a new balance ?

Haikuo — Wed, 19 Dec 2012 16:02:04 GMT

Keyword: retain.

data have;

input Year BondFV Called ;

cards;

1 100 0

2 100 5

3 100 0

4 100 0

5 100 4

6 100 0

;

data want;

set have;

if _n_=1 then newFV=bondfv;

newFV+(-called);

run;

Haikuo

Re: Can someone help me with create a new balance ?

Linlin — Wed, 19 Dec 2012 16:09:03 GMT

Haikuo,

Where is the Keyword?

Re: Can someone help me with create a new balance ?

Haikuo — Wed, 19 Dec 2012 16:16:46 GMT

Keyword of 'remain' is implied by using sum statement. Of course you can use it explicitly such as:

retain newfv;

Sorry for the confusion.

Haikuo

Re: Can someone help me with create a new balance ?

Anna_Guo — Wed, 19 Dec 2012 16:20:52 GMT

Thank you , Hai.Kuo. But I realized my problem is more complicated than this. ( I should have enbe more specific). I forgot to add that my sample inludes many companies, and each company has several action_types ( not juste being called, sometime paying for sinking fund). so I need to use by ID, and action_type, : if first.ID and first.action_type , something like that. newFV-called-sinkinfund

But thank you , anyway. I am not sure if I have limitation of numbers of posting each day in this website? I may repost my question.

Anna

Re: Can someone help me with create a new balance ?

Haikuo — Wed, 19 Dec 2012 16:23:19 GMT

No limit on the number of posts. Go ahead post your new question , hopefully with new sample data, so people can work on it right away.

Regards,

Haikuo