Annualize Totals for Current Year

Reply
Contributor
Posts: 23

Annualize Totals for Current Year

Hello All!

 

I'm looking to annualize my totals that I have through 05/31/2017 and looking to annualize for total current year based on the numbers through the end of May.

 

Example: $12,500 in total sales through 05/31/2017 and looking to annualize/project for full year of 2017 based on those current results.  Will also be performing the same calculating once June is complete.

 

I've been able to do this in Excel and wondering if this is at all possible in SAS.

 

Any help and/or coding examples will be greatly appreciated. =)

PROC Star
Posts: 736

Re: Annualize Totals for Current Year

Posted in reply to PhatRam33

Please provide some sample data in the form of a datastep Smiley Happy

Contributor
Posts: 23

Re: Annualize Totals for Current Year

Here is an example of what the data looks like

 

data work.temp;

format date date9.;

 

input

date mmddyy10.

type $

sales 8.

;

cards;

05/31/2017 APPLES 12500

05/31/2017 ORANGES 8000

;

run;

Super User
Posts: 19,782

Re: Annualize Totals for Current Year

Posted in reply to PhatRam33

This isn't just a technical question, you have to provide the methodology and you need historic to forecast out. 

 

You can look at the procedures in SAS/ETS (time series) data on how you might forecast your data.

 

 

Super User
Posts: 11,343

Re: Annualize Totals for Current Year

Posted in reply to PhatRam33

PhatRam33 wrote:

Hello All!

 

I'm looking to annualize my totals that I have through 05/31/2017 and looking to annualize for total current year based on the numbers through the end of May.

 

Example: $12,500 in total sales through 05/31/2017 and looking to annualize/project for full year of 2017 based on those current results.  Will also be performing the same calculating once June is complete.

 

I've been able to do this in Excel and wondering if this is at all possible in SAS.

 

Any help and/or coding examples will be greatly appreciated. =)


Describe the process you used in Excel.

If it is anything like assuming the sales will be the same for each month of the year and extrapolate that total to the end of the year then:

data work.temp;
   format date date9.;
   input
      date mmddyy10.
      type $
      sales 8.
   ;
   EstAnnualSale = (sales/month(date))*12;
cards;
05/31/2017 APPLES 12500
05/31/2017 ORANGES 8000
;
run;

The sales/(month(date)) determines average monthly sales to date.

 

Ask a Question
Discussion stats
  • 4 replies
  • 147 views
  • 0 likes
  • 4 in conversation