Re: How to enter cross-sectional time-series data into SPSS for correlation

Posted by dave on
URL: http://spssx-discussion.165.s1.nabble.com/How-to-enter-cross-sectional-time-series-data-into-SPSS-for-correlation-tp5726681p5726925.html

Thank you, PRogman. Thats a good point, will code 0 = no in the future.

I tried your syntax and it works fine until it comes to the correlations. Here SPSS is saying that the vars are constant (screenshot:corr.png ) - and error, that I in this case do not quite understand. Why is that happening?

Apart from that, I am still not sure whether the syntax is really computing what I need. Just to be sure:

countYes.1 == Sum of <Yes> in <Twitter> 
countYes.2 == Sum of <Yes> in <Spon>
totalCount.1 == Total number of Twitter n's
totalCount.2 == Total number of Spon n's

Is that right? If so, until now the correlation is not differentiating the time points, since countYes.1 and .2 are a SUM for all  available Ts (that is T1 & T2). Is that right?