Contributor
Posts: 37

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: 1,283

Re: Annualize Totals for Current Year

Please provide some sample data in the form of a datastep

Contributor
Posts: 37

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: 23,737

Re: Annualize Totals for Current Year

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: 13,554

Re: Annualize Totals for Current Year

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.

Discussion stats
• 4 replies
• 178 views
• 0 likes
• 4 in conversation