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 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1451 views
  • 0 likes
  • 2 in conversation