I have three categorical (A, B and C) and one continuous(D) variables with n>10 thousand. Each of the categorical has six levels. I want to construct a summary table where the A is in the row, B in the column and C in the sub column of B; then the cells of the table should contain the mean of D.
To construct the summary table, I got the aggregates, then constructed the OLAP cubes and did some pivoting. I was successful in doing it, but Its a very tedious process considering that I have to repeat the process several times because I have a plenty of continuous variables.
I appreciate if someone could suggest a syntax to do the same. Assume that I have the SPSS Table in my machine.
Thank you.
Johnny |
Share videos while chatting with your friends on messenger.
Now you can with the all-new Yahoo! Messenger.
Locked
