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-tp5726681p5726926.html

Sorry for doubleposting...

I just completed David's syntax with PRogman's suggestion. This fixes the output file, however, the correlation in David's file stops with the same error (vars are constant). Here are the two files:

David: DAVID.sav
PRogman: PROGman.sav

PRogman, in your output, the totalCounts indeed are constant, right?

David, while having a look at your file, I finally realized that TotalCount.1 and .2 are merged vars for Twitter + Spon and T1 & T2. That's a huge step in the right direction. However, I still can't differentiate precise enough, since I actually would only need to correlate TotalCount.1 and .2 BY <Topic>. Could that be solved by IF content = Cand_Juncker...?

To sum up:

1) Correlation in both files aren't working.
2) TotalCounts differ in both files (is that because PRogman recoded the data?).
3) Apart from that, to me as a nonspecialist the approach generally looks great. But, after corrs are finally working, how could I differentiate by Topic / content (by using IF..?)?