topic write a code in SAS Programming

write a code

niladri_routray — Tue, 18 Apr 2017 12:04:42 GMT

In a fixed term deposit of 25 years calculate the total amount at the end of term with initial
amount of 5,00,00 and annual interest rate of 7% i) compounded annually II) compaunded monthly. show the amount accured at monthly level.

Re: write a code

Kurt_Bremser — Tue, 18 Apr 2017 12:17:51 GMT

Please show the code you already tried, and where the result differed from your expected result.

Re: write a code

niladri_routray — Tue, 18 Apr 2017 12:21:26 GMT

I have not started yet. Please write code.

Re: write a code

Kurt_Bremser — Tue, 18 Apr 2017 12:22:33 GMT

My hourly fee for doing other people's work is 50 Euros. Can I send you my IBAN?

Re: write a code

novinosrin — Tue, 18 Apr 2017 12:25:00 GMT

Hi, I'm afraid your question doesn't sound like or request that essentially is a favor and rather that sounds like an order in a open public technical forum which is unfair. Please rephrase with some courtesy and kindess, you are more likely to get any kind of help you need. I am only suggesting, and do not take this personal. Thank you and have a nice day!

Re: write a code

niladri_routray — Tue, 18 Apr 2017 12:35:18 GMT

I am really sorry for your thoughts. I just started doing programming in SAS, thats why I posted this question and need a clue to start writing code. I did not know the protocol of this forum. If my question hurts anyone in this forum, I am saying sorry for that, no other intention.

Re: write a code

Kurt_Bremser — Tue, 18 Apr 2017 12:49:38 GMT

Hints:

In a data step, use a do loop. Set the initial amount before the loop. Calculate the increase in the loop (variable asssignment with simple mathematical formula), and use output to write a record (observation) to the target dataset.

Re: write a code

LinusH — Tue, 18 Apr 2017 12:54:53 GMT

If you are new to SAS programming, I would suggest that you take the free online Programming 1 course. It will help develop your skills, and hopefully be able to direct more specific question on these forums in the future.

Re: write a code

ballardw — Tue, 18 Apr 2017 14:43:06 GMT

Look in the online help for SAS functions such as FINANCE.

Re: write a code

Ksharp — Wed, 19 Apr 2017 07:21:14 GMT

If I was right.


data _null_;
year=0.07;
month=0.07/12;

do i=1 to 25;
 year_amount=50000*constant('e')**(year*i);
 put 'year=' i ' year amount=' year_amount;
end;

do i=1 to 25*12;
 month_amount=50000*constant('e')**(month*i);
 put 'month=' i ' month amount=' month_amount;
end;
run;

Re: write a code

niladri_routray — Wed, 19 Apr 2017 09:33:36 GMT

Hello,

Thanks for your reply.

while running the below code, I am getting following output.

year_amount=287730.13

and month_amount=287730.13

but calculation formula used in the code for year_amount and month_amount is differenet while output is same for both year_amount and month_amount.

Re: write a code

Ksharp — Wed, 19 Apr 2017 11:49:46 GMT

Can you show us the formula and the output ?

Re: write a code

niladri_routray — Wed, 19 Apr 2017 11:53:09 GMT

I used the code sent by you.

Re: write a code

Ksharp — Wed, 19 Apr 2017 11:56:10 GMT

I mean the formula for compounded interest annually and monthly .

Re: write a code

Ksharp — Wed, 19 Apr 2017 12:15:21 GMT

So you want sparse compound interest ,not continuous compound.



data _null_;
year=0.07;
month=0.07/12;

year_amount=50000;
do i=1 to 25;
 year_amount=year_amount*(1+year);
 put 'year=' i ' year amount=' year_amount;
end;

month_amount=50000;
do i=1 to 25*12;
 month_amount=month_amount*(1+month);
 put 'month=' i ' month amount=' month_amount;
end;
run;

Re: write a code

niladri_routray — Wed, 19 Apr 2017 12:25:17 GMT

I want amount compounded annually, compounded monthly also amount accrued at monthly level.please help

Re: write a code

niladri_routray — Wed, 19 Apr 2017 12:26:46 GMT

is there any document which help me calclaute all these financial term in SAS, where I can refer to.

Re: write a code

Ksharp — Wed, 19 Apr 2017 12:31:16 GMT

Search it at wikipedia.org


https://en.wikipedia.org/wiki/Compound_interest

Re: write a code

ballardw — Wed, 19 Apr 2017 16:20:02 GMT

Perhaps

data _null_;
   year=0.07;
   month=0.07/12;
   principal = 50000;
   do i=1 to 25;
      year_amount=compound(principal,.,year,i);
      int = year_amount-principal;
      put 'year=' i ' year amount=' year_amount f14.2 +1  "Accumulated interest=" int f14.2; ;
   end;

   do i=1 to 25*12;
      month_amount=compound(principal,.,month,i);
      int = month_amount-principal;
      put 'month=' i ' month amount=' month_amount f14.2 +1 "Accumulated interest=" int f14.2;
   end;
run;

Re: write a code

GinaRepole — Wed, 19 Apr 2017 16:34:57 GMT

ballardw has already given you some good code to get you started above. A lot of what you're looking for can be done through logical calculations using DATA step and DO loop syntax. Some functions may come in handy, as well.

If you need help with how to use financial functions, or wonder what is available, you can find them here by scrolling down to the Finance section.

If you have access to or are interested in any formal SAS training on this topic, the SAS Programming 2 course covers almost exactly this topic in Chapter 7.1 & 7.2.