https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Re-Correlations-between-consecutive-observations-grouped-by/m-p/621935#M3747 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/161013">@Wafflecakes</a>&nbsp;wrote: <P class="1580737608688">&nbsp;</P> <P>How would I do a correlation between consecutive years (grouped by id)? e.g. Correlation between measure1 in 2001 with measure1 in 2000, measure1 in 2002 with measure1 in 2001, etc.</P> <HR /></BLOCKQUOTE> <P>Normally, one does not speak of correlation between row 1 and row 2 of a data set. The correlation is not defined in this manner, and has no particular meaning. (Or, it is a degenerate case where the correlation between row 1 and row 2 is always equal to ±1)</P> <P>&nbsp;</P> <P>One can speak of a correlation of ALL the rows for a given variable where ID = 1, and a correlation between all the rows where ID = 2, but this is different than your row-by-row correlation.</P> <P>&nbsp;</P> <P>So, could you please clarify?</P> Mon, 03 Feb 2020 13:53:29 GMT PaigeMiller 2020-02-03T13:53:29Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Re-Correlations-between-consecutive-observations-grouped-by/m-p/621935#M3747 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/161013">@Wafflecakes</a>&nbsp;wrote: <P class="1580737608688">&nbsp;</P> <P>How would I do a correlation between consecutive years (grouped by id)? e.g. Correlation between measure1 in 2001 with measure1 in 2000, measure1 in 2002 with measure1 in 2001, etc.</P> <HR /></BLOCKQUOTE> <P>Normally, one does not speak of correlation between row 1 and row 2 of a data set. The correlation is not defined in this manner, and has no particular meaning. (Or, it is a degenerate case where the correlation between row 1 and row 2 is always equal to ±1)</P> <P>&nbsp;</P> <P>One can speak of a correlation of ALL the rows for a given variable where ID = 1, and a correlation between all the rows where ID = 2, but this is different than your row-by-row correlation.</P> <P>&nbsp;</P> <P>So, could you please clarify?</P> Mon, 03 Feb 2020 13:53:29 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/Re-Correlations-between-consecutive-observations-grouped-by/m-p/621935#M3747 PaigeMiller 2020-02-03T13:53:29Z