Dear List Members,
I am trying to get several statistics normally
produced by CTABLES to appear in a single table. I have two variables: Typol#7
which is a row variable and Barak_therm which is a column variable having six
values. I want the following statistics to be reported in this table: column
percentages in each column, the sum of the column percentages (100%) in
each column, the weighted total count in each column, and the mean of typol#7 in
each column. I should note that typol#7 has only three values which are -1,
0, +1. Using the syntax noted below, I do indeed get the correct column
sum, the correct weighted count, and the correct mean for typol#7 in each
column. Nevertheless, I am discovering that my syntax (see below) is
failing to provide the column percentages for each response option in
typol#7. I think that the reason for my failure is that I have
declared typol#7 as a scale variable in order to get the mean of typol#7 for
each column of the categorical variable called Barak_therm. Although I suspect
that there is a way to get all of my desired statistics in a single
table, I am unaware of the necessary trick. Thus, I welcome your help
on this matter.
CTABLES
/VLABELS VARIABLES=typol#7 Barak_therm DISPLAY=DEFAULT
/TABLE typol#7 [S][COLPCT.SUM PCT40.1, COUNT F40.0, MEAN F40.3] BY
Barak_therm [C]
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=Barak_therm ORDER=A KEY=VALUE
EMPTY=INCLUDE.
Thank you for your help.
David
Locked
