>implement all these things in my original data named as usage data data usage_data; set usage_data; will do that. But better to look at @Reeza 's solution. ... View more

proc imports recognizes Latest_Launch as SAS-date, so use the example code posted by @Reeza. ... View more

This post with the sample data is the most useful information you have provided.  Now add one more column to it, showing what the results should look like after the calculations are made.   Sample code is not required.  The posters here will assume that the data set you already posted is named HAVE, and the data set that needs to be created with the extra column added should be named WANT.   And check out the suggestion from @Patrick ... it is possible that this does exactly what you want.   And stay far away from INTCK until you are very sure of what it does.  Using your formulas, it is easy to come up with sample dates where NO_OF_MONTHS is 1, but NO_OF_WEEKS is 0. ... View more

You had posted the actual code you ran (including your libname statement and proc import) but, apparently, deleted that post.   If you repost it, I'm sure one of us can show you how to correctly run what you're trying to do.   Art, CEO, AnalystFinder.com   ... View more

@mehak wrote: Can any1 please help me . I have to calculate field of coupon issuance date .expiry date of coupon is 3 months . But in my data sets i am only having expiry date . Is this the correct way to solve such que      data _class_1; coupon_issuance_date=intnx('02',20,-3,'b'); proc print data = _class_1 noobs; run;   No. Review how the INTNX() documentation, there are examples at the bottom of the page.  http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p10v3sa3i4kfxfn1sovhi5xzxh8n.htm&docsetVersion=9.4&locale=en   Specifically: INTNX(interval <multiple><.shift-index>, start-from, increment <, 'alignment'>)   Compare the parameters above to yours. The examples are towards the bottom of the page.  ... View more

is this the correct way to solve 1 st one data work.invest; do month=1 to 15; Capital+5000; capital+(capital*.10); output; end; run;   2. data work.invest; amount=500000; rate=0.07; do month =1 to 25 ; earned+5000; output; end; run; title 'output dataset :Compounded monthly'; run; proc print data=work.invest; title 'output dataset :Compound Monthly'; run; /* Compounded ANNUALLY */ data work.invest; amount=500000; rate=0.07; do year =1 to 25; earned+5000; earned+(amount+earned)*rate; output; end; run; title 'output dataset :Compounded annually'; run; proc print data=work.invest; title 'output dataset :Compound annually'; run; ... View more