topic Re: Annualize Totals for Current Year in SAS Programming

Annualize Totals for Current Year

PhatRam33 — Tue, 20 Jun 2017 17:47:37 GMT

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. 😃

Re: Annualize Totals for Current Year

PeterClemmensen — Tue, 20 Jun 2017 18:10:42 GMT

Please provide some sample data in the form of a datastep 🙂

Re: Annualize Totals for Current Year

PhatRam33 — Tue, 20 Jun 2017 19:01:51 GMT

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;

Re: Annualize Totals for Current Year

Reeza — Tue, 20 Jun 2017 19:56:36 GMT

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.

Re: Annualize Totals for Current Year

ballardw — Wed, 21 Jun 2017 14:33:27 GMT

@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.