BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
YK1
Calcite | Level 5 YK1
Calcite | Level 5
 

Hello SAS support!

 

I'm just wondering how can I determine seasonality of weekly data using X11. 

I've already done using proc x11 with monthly data, but I want to see weekly seasonality to be more elaborate. 

Can anyone let me know the way to determine the trend, seasonality, irregularity of weekly data?

 

thanks in advance!

 

best,

YK

1 ACCEPTED SOLUTION

Accepted Solutions
udo_sas
SAS Employee

Hello -

"Seasonal adjustment of weekly data poses special problems because the data are not exactly periodic. The workhorse programs X-12 ARIMA, TRAMO/SEATS, and STAMP, are not suitable." - taken from http://www.jos.nu/Articles/abstract.asp?article=232209

 

The X11 and X12 (X13) procedures in the SAS/ETS product are based on the Fortran code provided by the U.S. Census Bureau.  Because the Census Bureau's X11 and X12 methodologies are limited to monthly and quarterly series, the X11 and X12 procedures in SAS are also limited to these two frequencies.  Other procedures that may be of interest to you for decomposing weekly data are the EXPAND, TIMESERIES, and UCM procedures in the SAS/ETS product.

 

Given the JOS Online Article I'm refering to talks about UCM - you may want to check out http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_ucm_gettingsta... to get started.

 

Thanks,

Udo

 

 

View solution in original post

1 REPLY 1
udo_sas
SAS Employee

Hello -

"Seasonal adjustment of weekly data poses special problems because the data are not exactly periodic. The workhorse programs X-12 ARIMA, TRAMO/SEATS, and STAMP, are not suitable." - taken from http://www.jos.nu/Articles/abstract.asp?article=232209

 

The X11 and X12 (X13) procedures in the SAS/ETS product are based on the Fortran code provided by the U.S. Census Bureau.  Because the Census Bureau's X11 and X12 methodologies are limited to monthly and quarterly series, the X11 and X12 procedures in SAS are also limited to these two frequencies.  Other procedures that may be of interest to you for decomposing weekly data are the EXPAND, TIMESERIES, and UCM procedures in the SAS/ETS product.

 

Given the JOS Online Article I'm refering to talks about UCM - you may want to check out http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_ucm_gettingsta... to get started.

 

Thanks,

Udo

 

 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1555 views
  • 0 likes
  • 2 in conversation