SPSSX Discussion

Displaying User-Missing and System-Missing Totals in Custom Tables

Classic

List

Threaded

6 messages Options

Aaron Weis

Displaying User-Missing and System-Missing Totals in Custom Tables

missing cases, number of user-missing cases, and then the percent of cases selecting different responses.

If requested, I can provide a word doc that shows the table I can get from Custom Tables and a table that shows what I want to present (essentially splitting the Missing Totals into two categories).

In essence, the code below shows the total amount of missing data I have across both user- and system-missing data. I am searching for a way to parse the missing into two categories, the number of cases with user-missing data and the number of cases with system-missing data.

CTABLES

/VLABELS VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f DISPLAY=LABEL

/TABLE

spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

spq1e [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

spq1f [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']]

/CLABELS ROWLABELS=OPPOSITE

/CATEGORIES VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f

ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE

/TITLES TITLE='SPQ: Q1'

CORNER='Which of the following describe your position?'.

Best,

Aaron

Jon K Peck

Re: Displaying User-Missing and System-Missing Totals in Custom Tables

System-missing values are never included in a custom table. If you assign these to a user missing value, you can tabulate them. PCOMPUTE may be useful here in specifying the exact percentages you want.

BTW, you can simplify the table expression below by factoring out the statistics, e.g., instead of
/TABLE
spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

use
/table
(spq1a+spq1b + ...)[rowpct.count 'Percent' totals[validn missing 'Missing N']]

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: Aaron Weis <[hidden email]>
To: [hidden email]
Date: 07/05/2012 02:33 PM
Subject: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Is there a way in custom tables to display both the system-missing and user-missing N under the Totals category? I need to create tables that display the number of valid cases (VALIDN), number of system-
missing cases, number of user-missing cases, and then the percent of cases selecting different responses.

If requested, I can provide a word doc that shows the table I can get from Custom Tables and a table that shows what I want to present (essentially splitting the Missing Totals into two categories).

In essence, the code below shows the total amount of missing data I have across both user- and system-missing data. I am searching for a way to parse the missing into two categories, the number of cases with user-missing data and the number of cases with system-missing data.

CTABLES
/VLABELS VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f DISPLAY=LABEL
/TABLE
spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1e [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1f [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']]
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f
ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE
/TITLES TITLE='SPQ: Q1'
CORNER='Which of the following describe your position?'.

Best,
Aaron

Aaron Weis

Re: Displaying User-Missing and System-Missing Totals in Custom Tables

Thanks for syntax pointer, Jon!

In regards to the table, I am not wanting to include the percentage of system-missing in my custom table. Rather, I was to differentiate the missing Ns (or count of cases missing) in my ‘Totals’ columns so that someone can see if someone is missing the data point due to system-missing (skipped items in our case) or user-missing (item not presented by design). I hope this is a bit clearer than my first attempt.

Thank,

Aaron

From: Jon K Peck [mailto:[hidden email]]
Sent: Thursday, July 05, 2012 4:58 PM
To: Aaron Weis
Cc: [hidden email]
Subject: Re: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables

Jon K Peck

Re: Displaying User-Missing and System-Missing Totals in Custom Tables

System-missing values will never appear, but since you can have three user-missing values, why not recode (temporarily or otherwise), the sysmis values to a user-missing value? It is good practice to use user missing codes for the type of missings you describe and leave sysmis for uncomputable values such as division by zero or the log of a nonpositive number.

HTH,

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: Aaron Weis <[hidden email]>
To: Jon K Peck/Chicago/IBM@IBMUS
Cc: "[hidden email]" <[hidden email]>
Date: 07/09/2012 06:33 AM
Subject: RE: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables

Thanks for syntax pointer, Jon!

In regards to the table, I am not wanting to include the percentage of system-missing in my custom table. Rather, I was to differentiate the missing Ns (or count of cases missing) in my ‘Totals’ columns so that someone can see if someone is missing the data point due to system-missing (skipped items in our case) or user-missing (item not presented by design). I hope this is a bit clearer than my first attempt.

Thank,

Aaron

From: Jon K Peck [mailto:peck@...]
Sent: Thursday, July 05, 2012 4:58 PM
To: Aaron Weis
Cc: [hidden email]
Subject: Re: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables

System-missing values are never included in a custom table. If you assign these to a user missing value, you can tabulate them. PCOMPUTE may be useful here in specifying the exact percentages you want.

BTW, you can simplify the table expression below by factoring out the statistics, e.g., instead of
/TABLE
spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

use
/table
(spq1a+spq1b + ...)[rowpct.count 'Percent' totals[validn missing 'Missing N']]

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
peck@...
new phone: 720-342-5621

From: Aaron Weis <[hidden email]>
To: [hidden email]
Date: 07/05/2012 02:33 PM
Subject: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Art Kendall

Re: Displaying User-Missing and System-Missing Totals in Custom Tables

AMEN!

Art Kendall
Social Research Consultants

On 7/9/2012 8:39 AM, Jon K Peck wrote:

System-missing values will never appear, but since you can have three user-missing values, why not recode (temporarily or otherwise), the sysmis values to a user-missing value? � It is good practice to use user missing codes for the type of missings you describe and leave sysmis for uncomputable values such as division by zero or the log of a nonpositive number.

HTH,

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: � � � � Aaron Weis [hidden email]
To: � � � � Jon K Peck/Chicago/IBM@IBMUS
Cc: � � � � [hidden email] [hidden email]
Date: � � � � 07/09/2012 06:33 AM
Subject: � � � � RE: [SPSSX-L] Displaying User-Missing and System-Missing Totals in � � � � � � � Custom Tables

�
Thanks for syntax pointer, Jon! �
�
In regards to the table, I am not wanting to include the percentage of system-missing in my custom table. � Rather, I was to differentiate the missing Ns (or count of cases missing) in my ‘Totals’ columns so that someone can see if someone is missing the data point due to system-missing (skipped items in our case) or user-missing (item not presented by design). � I hope this is a bit clearer than my first attempt.
�
Thank,
�
Aaron
�
�
From: Jon K Peck [[hidden email]]
Sent: Thursday, July 05, 2012 4:58 PM
To: Aaron Weis
Cc: [hidden email]
Subject: Re: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables
�
System-missing values are never included in a custom table. � If you assign these to a user missing value, you can tabulate them. � PCOMPUTE may be useful here in specifying the exact percentages you want.

BTW, you can simplify the table expression below by factoring out the statistics, e.g., instead of
/TABLE
� spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

use
/table
(spq1a+spq1b + ...)[rowpct.count 'Percent' totals[validn missing 'Missing N']]

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: � � � � Aaron Weis <[hidden email]>
To: � � � � [hidden email]
Date: � � � � 07/05/2012 02:33 PM
Subject: � � � � [SPSSX-L] Displaying User-Missing and System-Missing Totals in � � � � � � � Custom Tables
Sent by: � � � � "SPSSX(r) Discussion" <[hidden email]>

Is there a way in custom tables to display both the system-missing and � user-missing N under the Totals category? � I need to create tables that display the number of valid cases (VALIDN), number of system- � � �
missing cases, number of user-missing cases, and then the percent of cases selecting different responses. � � � � � � � � � � � � � � � � � �
� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �
If requested, I can provide a word doc that shows the table I can get from Custom Tables and a table that shows what I want to present (essentially splitting the Missing Totals into two categories). � � �
�
In essence, the code below shows the total amount of missing data I have across both user- and system-missing data. � I am searching for a way to parse the missing into two categories, the number of cases with user-missing data and the number of cases with system-missing data.
�
CTABLES
� /VLABELS VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f DISPLAY=LABEL
� /TABLE
� spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1e [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1f [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']]
� /CLABELS ROWLABELS=OPPOSITE
� /CATEGORIES VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f
� � ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE
� /TITLES TITLE='SPQ: Q1'
� � CORNER='Which of the following describe your position?'.
�
�
Best,
Aaron

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

Art Kendall
Social Research Consultants

Art Kendall

Re: Displaying User-Missing and System-Missing Totals in Custom Tables

Overview (MISSING VALUES command)

MISSING VALUES declares values user-missing. These values can then receive special treatment in data transformations, statistical calculations, and case selection. By default, user-missing values are treated the same as the system-missing values. System-missing values are automatically assigned by the program when no legal value can be produced, such as when an alphabetical character is encountered in the data for a numeric variable, or when an illegal calculation, such as division by 0, is requested in a data transformation.

<a style="display: inline;" id="N317D1_closer" name="N317D1_closer" href="javascript:expando('N317D1');"> Hide details

Basic Specification

The basic specification is a single variable followed by the user-missing value or values in parentheses. Each specified value for the variable is treated as user-missing for any analysis.

<a style="display: inline;" id="N317DE_closer" name="N317DE_closer" href="javascript:expando('N317DE');"> Hide details

Syntax Rules

•� Each variable can have a maximum of three individual user-missing values. A space or comma must separate each value. For numeric variables, you can also specify a range of missing values. See the topic Specifying Ranges of Missing Values (MISSING VALUES command) for more information.

often it is possible to have many many missing values codes.
Missing values x(lo thru -1).
or
Missing values y (0, 1000 thru hi).

Art Kendall
Social Research Consultants

On 7/10/2012 1:21 PM, Art Kendall wrote:

AMEN!
Art Kendall
Social Research Consultants
On 7/9/2012 8:39 AM, Jon K Peck wrote:
System-missing values will never appear, but since you can have three user-missing values, why not recode (temporarily or otherwise), the sysmis values to a user-missing value? � It is good practice to use user missing codes for the type of missings you describe and leave sysmis for uncomputable values such as division by zero or the log of a nonpositive number.

HTH,

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: � � � � Aaron Weis [hidden email]
To: � � � � Jon K Peck/Chicago/IBM@IBMUS
Cc: � � � � [hidden email] [hidden email]
Date: � � � � 07/09/2012 06:33 AM
Subject: � � � � RE: [SPSSX-L] Displaying User-Missing and System-Missing Totals in � � � � � � � Custom Tables

�
Thanks for syntax pointer, Jon! �
�
In regards to the table, I am not wanting to include the percentage of system-missing in my custom table. � Rather, I was to differentiate the missing Ns (or count of cases missing) in my ‘Totals’ columns so that someone can see if someone is missing the data point due to system-missing (skipped items in our case) or user-missing (item not presented by design). � I hope this is a bit clearer than my first attempt.
�
Thank,
�
Aaron
�
�
From: Jon K Peck [[hidden email]]
Sent: Thursday, July 05, 2012 4:58 PM
To: Aaron Weis
Cc: [hidden email]
Subject: Re: [SPSSX-L] Displaying User-Missing and System-Missing Totals in Custom Tables
�
System-missing values are never included in a custom table. � If you assign these to a user missing value, you can tabulate them. � PCOMPUTE may be useful here in specifying the exact percentages you want.

BTW, you can simplify the table expression below by factoring out the statistics, e.g., instead of
/TABLE
� spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +

use
/table
(spq1a+spq1b + ...)[rowpct.count 'Percent' totals[validn missing 'Missing N']]

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621

From: � � � � Aaron Weis <[hidden email]>
To: � � � � [hidden email]
Date: � � � � 07/05/2012 02:33 PM
Subject: � � � � [SPSSX-L] Displaying User-Missing and System-Missing Totals in � � � � � � � Custom Tables
Sent by: � � � � "SPSSX(r) Discussion" <[hidden email]>

Is there a way in custom tables to display both the system-missing and � user-missing N under the Totals category? � I need to create tables that display the number of valid cases (VALIDN), number of system- � � �
missing cases, number of user-missing cases, and then the percent of cases selecting different responses. � � � � � � � � � � � � � � � � � �
� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �
If requested, I can provide a word doc that shows the table I can get from Custom Tables and a table that shows what I want to present (essentially splitting the Missing Totals into two categories). � � �
�
In essence, the code below shows the total amount of missing data I have across both user- and system-missing data. � I am searching for a way to parse the missing into two categories, the number of cases with user-missing data and the number of cases with system-missing data.
�
CTABLES
� /VLABELS VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f DISPLAY=LABEL
� /TABLE
� spq1a [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1b [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1c [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1d [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1e [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']] +
� spq1f [ROWPCT.COUNT 'Percent' F40.0, TOTALS[VALIDN F40.0, MISSING 'Missing N']]
� /CLABELS ROWLABELS=OPPOSITE
� /CATEGORIES VARIABLES=spq1a spq1b spq1c spq1d spq1e spq1f
� � ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=BEFORE
� /TITLES TITLE='SPQ: Q1'
� � CORNER='Which of the following describe your position?'.
�
�
Best,
Aaron

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

Art Kendall
Social Research Consultants