Construction of tables containing means

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Construction of tables containing means

Johnny Amora
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


Surf faster and smarter with Firefox 3!
Reply | Threaded
Open this post in threaded view
|

Re: Construction of tables containing means

ViAnn Beadle

Use the Custom Tables dialog to generate one such table and paste it. Then place the cursor within the pasted syntax, hit F1 to get to the Help on the CTABLES syntax.

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Johnny Amora
Sent: Friday, March 06, 2009 3:50 AM
To: [hidden email]
Subject: Construction of tables containing means

 

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

 


Surf faster and smarter with Firefox 3!