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

Sorry David, I wasn't at my local PC with SPSS. I now tried your syntax. It produces an error but still spits out two new files.

File 1 switches cases to vars, right? So that I have n = 343 vars for: ArticleID, Outlet, Time and TopicCount.

And file 2 contains total counts for every topic by Tx, Day, Outlet. That looks nice, thank you! However, I still don't understand: How can I use File 2 to compute the mentioned correlations? Maybe I should precede using your File 2 and IF argument to produce the combined vars?

Maybe my lack of understanding is due to the error? SPSS says it occurs on line 9 (CORRELATIONS TOTALCount.1 WITH Totalcount.2 .):

"9 Correlations Text: TOTALCount.1 Befehl: CORRELATIONS
SYNTAXFEHLER: Ein Unterbefehls- oder Variablennamen wird hier erwartet. Möglicherweise wurde ein Variablenname falsch geschrieben.  Gültige Unterbefehle für diese Prozedur sind VARIABLES, MISSING, PRINT, FORMAT, MATRIX und STATISTICS.
Die Ausführung dieses Befehls wurde gestoppt. "

In english: "[...] Syntaxerror: A sub-command or variablename is expected here. Maybe the var-name is written wrong. [...]"

Wondered whether the syntax is case sensitive, but the error remains. Mayb its because in File 2 there is only one var named "TotalCount" but not "TotalCount 1" and "TotalCount 2"?