SPSSX Discussion

Column N% and Valid Column N%

Classic

List

Threaded

3 messages Options

james.moffitt

Column N% and Valid Column N%

I’m running some Custom Tables in SPSS 15.0.

I have 106 cases in my data set.

I created a Custom Table, in part, by choosing both Column N% and Column Valid N% under the N% Summary Statistic options.

Those two columns are displayed side-by-side in the resulting table.

I expected the column percentages to differ inasmuch as I have one system missing case (I expected the percentages in one column to be based to 106 and the percentages in the other column to be based to 105). Instead, the percentages in the two columns are identical to three decimal places.

I’ve listed my syntax below.

Does anyone know how I might achieve the result I want?

Thanks in advance.

CTABLES

/VLABELS VARIABLES=JurisdictionBreak Wave Q6 DISPLAY=DEFAULT

/TABLE Q6 BY JurisdictionBreak [COUNT F40.3, COLPCT.COUNT PCT40.3,

COLPCT.VALIDN PCT40.3] + Wave [COUNT F40.0, COLPCT.COUNT PCT40.3,

COLPCT.VALIDN PCT40.3]

/CATEGORIES VARIABLES=JurisdictionBreak Q6 ORDER=A KEY=VALUE EMPTY=INCLUDE

TOTAL=YES POSITION=BEFORE

/CATEGORIES VARIABLES=Wave ORDER=A KEY=VALUE EMPTY=INCLUDE.

Patrick Kyba

Re: Column N% and Valid Column N%

Try the following:

1. Recode your system missing value to a value and define this value to be missing. Note that you want to chose some value that isn't already in your other variables.

2. Show the missing values in your table. You can do this in the Custom Tables dialog box or add "Missing = Include" after your "Empty = Include" commands below.

I tried this with some fake data and it seemed to work for me (on SPSS 15.0).

Patrick

[hidden email] wrote:

I’m running some Custom Tables in SPSS 15.0.

I have 106 cases in my data set.

I created a Custom Table, in part, by choosing both Column N% and Column Valid N% under the N% Summary Statistic options.

Those two columns are displayed side-by-side in the resulting table.

I expected the column percentages to differ inasmuch as I have one system missing case (I expected the percentages in one column to be based to 106 and the percentages in the other column to be based to 105). Instead, the percentages in the two columns are identical to three decimal places.

I’ve listed my syntax below.

Does anyone know how I might achieve the result I want?

Thanks in advance.

CTABLES

/VLABELS VARIABLES=JurisdictionBreak Wave Q6 DISPLAY=DEFAULT

/TABLE Q6 BY JurisdictionBreak [COUNT F40.3, COLPCT.COUNT PCT40.3,

COLPCT.VALIDN PCT40.3] + Wave [COUNT F40.0, COLPCT.COUNT PCT40.3,

COLPCT.VALIDN PCT40.3]

/CATEGORIES VARIABLES=JurisdictionBreak Q6 ORDER=A KEY=VALUE EMPTY=INCLUDE

TOTAL=YES POSITION=BEFORE

/CATEGORIES VARIABLES=Wave ORDER=A KEY=VALUE EMPTY=INCLUDE.

--
Patrick Kyba
Senior Technical Analyst
Advanis

Unintended Recipient & Unauthorized Use of E-Mail:
This message and attachments may contain confidential or privileged
information that is intended only for the named recipient of this
e-mail. Any unauthorized use or distribution is not permitted. If you
have received this e-mail in error, deleting the e-mail and notifying
the sender would be appreciated. Thank you.