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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 1816 views
  • 0 likes
  • 2 in conversation