SPSS Statistics 25 crosstab
Locked
SPSS Statistics 25 crosstab
 
|
Crosstabs is no longer including system missing fields for numeric fields, completely ignores them. How do I turn this back on??
Crosstab a text field with a numeric and it leaves out all system missing without a warning message. Barbara Lombardo Institutional Research Camden County College Blackwood NJ 08012 Office: 856-374-4961 Fax: 856-374-5016 Think before you print. CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this e-mail in error, please notify the sender and delete this e-mail from your system. - Please consider the environment before printing this email. - ===================== 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 |
|
|
AFAIK, system missing values have never been included in a crosstabs table. I currently have V24 and 25 installed, and neither shows them. However, the Case Processing Table that precedes the crosstab table does show the count and percentage of these missing values. On Thu, Nov 9, 2017 at 11:29 AM, Lombardo, Barbara <[hidden email]> wrote: Crosstabs is no longer including system missing fields for numeric fields, completely ignores them. How do I turn this back on?? |
Administrator
|
Like Jon, I don't remember CROSSTABS ever including missing values. If you
want to include them, I think you'll have to recode SYSMIS to some numeric value (e.g., 999), and omit the MISSING VALUES command that would normally follow. You may want to include ADD VALUE LABELS though, to assign a "Missing" label . Jon Peck wrote > AFAIK, system missing values have never been included in a crosstabs > table. I currently have V24 and 25 installed, and neither shows them. > However, the Case Processing Table that precedes the crosstab table does > show the count and percentage of these missing values. > > On Thu, Nov 9, 2017 at 11:29 AM, Lombardo, Barbara < > BLombardo@ > > > wrote: > >> Crosstabs is no longer including system missing fields for numeric >> fields, >> completely ignores them. How do I turn this back on?? >> Crosstab a text field with a numeric and it leaves out all system missing >> without a warning message. >> >> >> >> Barbara Lombardo >> >> Institutional Research >> Camden County College >> Blackwood NJ 08012 >> Office: 856-374-4961 >> Fax: 856-374-5016 >> >> Think before you print. >> CONFIDENTIALITY: This e-mail (including any attachments) may contain >> confidential, proprietary and privileged information, and unauthorized >> disclosure or use is prohibited. If you received this e-mail in error, >> please notify the sender and delete this e-mail from your system. >> >> >> - Please consider the environment before printing this email. - >> >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> > LISTSERV@.UGA > (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 >> > > > > -- > Jon K Peck > jkpeck@ > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== 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
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
|
In CROSSTABS, for user missing values, you can always use:
cro varx by vary /missing inc. . . but this doesn't get round sysmis John F Hall [Retired academic survey researcher] IBM-SPSS Academic Author 9900074 Website: http://surveyresearch.weebly.com/ SPSS course: http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html Research: http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bruce Weaver Sent: 10 November 2017 00:08 To: [hidden email] Subject: Re: SPSS Statistics 25 crosstab Like Jon, I don't remember CROSSTABS ever including missing values. If you want to include them, I think you'll have to recode SYSMIS to some numeric value (e.g., 999), and omit the MISSING VALUES command that would normally follow. You may want to include ADD VALUE LABELS though, to assign a "Missing" label . Jon Peck wrote > AFAIK, system missing values have never been included in a crosstabs > table. I currently have V24 and 25 installed, and neither shows them. > However, the Case Processing Table that precedes the crosstab table > does show the count and percentage of these missing values. > > On Thu, Nov 9, 2017 at 11:29 AM, Lombardo, Barbara < > BLombardo@ > > > wrote: > >> Crosstabs is no longer including system missing fields for numeric >> fields, completely ignores them. How do I turn this back on?? >> Crosstab a text field with a numeric and it leaves out all system >> missing without a warning message. >> >> >> >> Barbara Lombardo >> >> Institutional Research >> Camden County College >> Blackwood NJ 08012 >> Office: 856-374-4961 >> Fax: 856-374-5016 >> >> Think before you print. >> CONFIDENTIALITY: This e-mail (including any attachments) may contain >> confidential, proprietary and privileged information, and >> unauthorized disclosure or use is prohibited. If you received this >> e-mail in error, please notify the sender and delete this e-mail from your system. >> >> >> - Please consider the environment before printing this email. - >> >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> > LISTSERV@.UGA > (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 >> > > > > -- > Jon K Peck > jkpeck@ > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- -- Bruce Weaver [hidden email] http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." NOTE: My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== 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 ===================== 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 |
|
In reply to this post by Bruce Weaver
If I recall correctly even back in 1972 system missing was not included in
crosstabs. I strongly suggest that you that you clean and prepare your data before you do runs for analysis. It is good practice to reserve sysmis for what it was designed for-- to have a signal when the system is unable to follow your instructions. Redraft your syntax until you have labelled all missing values, etc. Why is your data missing? When you know why a value is missing it is user missing. You can have many user missing values with labels. for many variables negative values are outside the legitimate range of values so you could do something like Missing values myvar (low thru -1). add value labels myvar -1 "not applicable" -2 "paper not readable" -3 "test eqpt failed" -4 "refused to answer" . . . another example when legitimate values go up 5 places before the decimal point is to use 6 digits Missing values myvar (100000 thru hi). add value labels myvar 100000 "not applicable" 100001 "refused to answer" 100002 "page not printed on form" . . . ----- Art Kendall Social Research Consultants -- Sent from: http://spssx-discussion.1045642.n5.nabble.com/ ===================== 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 |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |