A Data Science Central Community

Determining seasonality, deseasonlizing seasonal data, getting trend indices, getting seasonality indices have always been a boring nightmare for Analysts when it comes to analysing percentage increase in some parameter like sales, visits, frauds etc., negating the effects due to seasonality. All the above mentioned so called "NIGHTMARES"can be easily handled with the powerful but less used SAS procedure called PROC X11.

PROC X11 works as below,

It splits the actual data into three parts

1. The Seasonality Component (Seasonal peaks, dips etc.,)

2. The Trend Component (Positive/Negative slope in the data plot)

3. Irregular/Random component (which cannot be explained by trend and seasonlity)

The Proc X11 output contains the following series ,

b1 represents the original data

d10 represents the seasonality component in the data

d11 represents the deseasonlised data, i.e., the data made free of seasonal peaks/dips

d12 represents the trend component

and lastly d13 represents the random/irregular component in the data

Advantages:

1. Prevents the analysts from spending lots of time by writing long formulae in Excel/SAS to get rid of seasonality

2. Also gives a neat continuous variable expalining seasonality, trend etc.,

3. Very powerful trend/seasonlity analysis technique

4. Very useful for predicting trends/seasonlity for better accuracy of forecasts

Limitations:

1. Can be used only if there is minimum three years of data (either quarterly/monthly)

SAS Code to run PROC X11:

proc x11 data=dataset;

monthly date=date;/*needs to be in date9. format*/

tables d10 d11 d12 d13;

output out=output_dataset b1=originald10=seasonald11=adjustedd12=trendd13=irreg;

var variable;/*variable is the variable to be analysed*/

run;

PROC X11 works as below,

It splits the actual data into three parts

1. The Seasonality Component (Seasonal peaks, dips etc.,)

2. The Trend Component (Positive/Negative slope in the data plot)

3. Irregular/Random component (which cannot be explained by trend and seasonlity)

The Proc X11 output contains the following series ,

b1 represents the original data

d10 represents the seasonality component in the data

d11 represents the deseasonlised data, i.e., the data made free of seasonal peaks/dips

d12 represents the trend component

and lastly d13 represents the random/irregular component in the data

Advantages:

1. Prevents the analysts from spending lots of time by writing long formulae in Excel/SAS to get rid of seasonality

2. Also gives a neat continuous variable expalining seasonality, trend etc.,

3. Very powerful trend/seasonlity analysis technique

4. Very useful for predicting trends/seasonlity for better accuracy of forecasts

Limitations:

1. Can be used only if there is minimum three years of data (either quarterly/monthly)

SAS Code to run PROC X11:

proc x11 data=dataset;

monthly date=date;/*needs to be in date9. format*/

tables d10 d11 d12 d13;

output out=output_dataset b1=originald10=seasonald11=adjustedd12=trendd13=irreg;

var variable;/*variable is the variable to be analysed*/

run;

© 2020 TechTarget, Inc. Powered by

Badges | Report an Issue | Privacy Policy | Terms of Service

**Most Popular Content on DSC**

To not miss this type of content in the future, subscribe to our newsletter.

- Book: Applied Stochastic Processes
- Long-range Correlations in Time Series: Modeling, Testing, Case Study
- How to Automatically Determine the Number of Clusters in your Data
- New Machine Learning Cheat Sheet | Old one
- Confidence Intervals Without Pain - With Resampling
- Advanced Machine Learning with Basic Excel
- New Perspectives on Statistical Distributions and Deep Learning
- Fascinating New Results in the Theory of Randomness
- Fast Combinatorial Feature Selection

**Other popular resources**

- Comprehensive Repository of Data Science and ML Resources
- Statistical Concepts Explained in Simple English
- Machine Learning Concepts Explained in One Picture
- 100 Data Science Interview Questions and Answers
- Cheat Sheets | Curated Articles | Search | Jobs | Courses
- Post a Blog | Forum Questions | Books | Salaries | News

**Archives:** 2008-2014 |
2015-2016 |
2017-2019 |
Book 1 |
Book 2 |
More

**Most popular articles**

- Free Book and Resources for DSC Members
- New Perspectives on Statistical Distributions and Deep Learning
- Time series, Growth Modeling and Data Science Wizardy
- Statistical Concepts Explained in Simple English
- Machine Learning Concepts Explained in One Picture
- Comprehensive Repository of Data Science and ML Resources
- Advanced Machine Learning with Basic Excel
- Difference between ML, Data Science, AI, Deep Learning, and Statistics
- Selected Business Analytics, Data Science and ML articles
- How to Automatically Determine the Number of Clusters in your Data
- Fascinating New Results in the Theory of Randomness
- Hire a Data Scientist | Search DSC | Find a Job
- Post a Blog | Forum Questions

## You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge