BookmarkSubscribeRSS Feed
sassygrl
Calcite | Level 5
I noticed that the crosscorrelation plot shows both positive and negative lags. I have a situation where only lag -1 has a significant crosscorrelation, but I don't think that is actionable?? I've prewhitened and taken the first difference of the response series and the explanatory variable. Thanks!
3 REPLIES 3
udo_sas
SAS Employee
Hello -
The cross-correlation test of two time-series data sets involves many calculations of the correlation r by time-shifting the one data set relative to the other data set. Each shift is called a "lag", and the lag time is simply the sampling period of the two time-series data sets. A typical cross-correlation graph shows enough lags in both negative and positive directions to show the cyclical relationship of the two sets of data.
Does that help?
Regards,
Udo
sassygrl
Calcite | Level 5
Hello Udo,

Thank you, that does help shed light on the purpose of the crosscorrelation graph. In lieu of any cyclical relationship, is the significant crosscorrelation at lag -1 actionable? I am interpreting to results to mean that the explanatory variable is not useful.

Thanks!
udo_sas
SAS Employee
Hello -
Not sure of your specific situation, but there are cases where a crosscorrelation value of -1 is of practical usage. See for example: http://jds.fass.org/cgi/reprint/75/7/1891.pdf. Taken from there: "The significant negative crosscorrelation between milk yield and cholesterol on the same day suggests that serum cholesterol may be removed in milk or, more probably, that alterations in metabolism required for increased milk yield result in lower blood cholesterol."
Regards,
Udo Message was edited by: udo@sas

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 3 replies
  • 1003 views
  • 0 likes
  • 2 in conversation