Ooooh! I never would have guessed. Thanks. I did use means. I was looking for an output structure that required minimal editing to a set of tables.
You don’t have to offer a reply to the following comment. I’m not asking for one.
It seems odd to me that a procedure that seems to be about reporting DV statistics by IV categories would have a collapsed view as the default.
Gene Maguin
From: Rick Oliver [mailto:[hidden email]]
Sent: Wednesday, July 31, 2013 3:02 PM
To: Maguin, Eugene
Cc: [hidden email]
Subject: Re: Olap Cubes problem
Measurement level doesn't matter. OLAP cubes are initially collapsed to the total level. If you activate the table, you can use the drop-downs to view the various subgroups. You can also pivot the table to expose more layers at the same time -- or you could use the MEANS procedure.
Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
From: "Maguin, Eugene" <[hidden email]>
To: [hidden email],
Date: 07/31/2013 01:11 PM
Subject: Olap Cubes problem
Sent by: "SPSSX(r) Discussion" <[hidden email]>
I’m having problem with the Olap Cubes command. My syntax is
OLAP CUBES Requirements Appeal BY Primary_work_recoded Tx_v_support/CELLS=COUNT MEAN STDDEV.
What I’m getting back is the total sample N, mean, SD for the two DVs. I don’t know whether it matters or not but the DVs are scale level and the two IVs were initially nominal but changing them to ordinal made no difference. Several years ago I ran an Olap command that worked and this command string is structurally the same as the previous one. I must be doing something wrong but I don’t see what it is. Help please.
Thanks, Gene Maguin
Locked
