```Date: Tue, 29 Sep 2009 11:21:28 -0700 Reply-To: "Terjeson, Mark" Sender: "SAS(r) Discussion" From: "Terjeson, Mark" Subject: Re: Number Conversion into Millions & Calculation based on # of days in a month Comments: To: Sdlentertd In-Reply-To: A Content-Type: text/plain; charset="us-ascii" Hi, 1 round(362507841.7,1e6)/1e6 2) DaysThisMonth = intnx('month',date(),0,'e') - intnx('month',date(),0,'b') + 1; so then you could do your formula \$ / DaysThisMonth * 365 Hope this is helpful. Mark Terjeson Investment Business Intelligence Investment Management & Research Russell Investments 253-439-2367 Russell Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Sdlentertd Sent: Tuesday, September 29, 2009 10:57 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Number Conversion into Millions & Calculation based on # of days in a month 1) If I have this number 362507841.7 How can I make it so it only shows 363 (in millions)? 2)Also is there a formula where depending on what month it is, it will calculate the profit like this: if it's Jan (31 days) = \$ / 31 *365 if it's Feb 2008 (29 days) = \$ / 29 *365 if it's Feb 2009 (28 days) = \$ / 28 *365 if it's Apr (30 days) = \$ / 30 *365 Thank you ```

Back to: Top of message | Previous page | Main SAS-L page