In SPSS 15 there was a GUI menu:
Analyze > Tables > Tables of
Frequencies which could produce this:
. . .and produced automatic syntax:
TABLES /FORMAT BLANK MISSING('.')
/TABLES (LABELS) BY ( v16 + v17 + v18 + v19 + v20
) /STATISTICS COUNT ((F5.0) 'Count' ) .
This menu has disappeared from 18, but the syntax still works: all I
can find in the GUI for 18 is:
Analyze > Tables > Custom Tables . . . which can only produce this:
or this:
I've tried everything I can think of (including editing the pivot table) to
get the correct format, but so far woithout success. Is there any way I
can get the first table from 18 via the GUI without using scripts, micros
etc? This is for inclusion in a tutorial on multiple response for nervous
beginners, not a demo for experts. The syntax is too complex for them to
understand at this point in the course.
|
All you need to do to get the table of
frequencies layout is to drag your categorical variables to the columns
and then drop the Category Position control in the bottom right and choose
Column Labels in Row.
In syntax, using 1991 GSS as an example CTABLES /TABLE BY hlth1 + hlth2+hlth3+hlth4+hlth5 /CLABELS COLLABELS=OPPOSITE. The key is the last subcommand. The generated table is copied below (as plain text :-)) There is a restriction in the gui that the value label sets must be the same for all the variables when doing this. Otherwise it would be impossible to label the rows correctly. Ill Enough to Go to a Doctor Counselling for Mental Problems Infertility, Unable to Have a Baby Drinking Problem Illegal Drugs (Marijuana, Cocaine) Count Count Count Count Count Yes 559 58 35 17 30 No 454 955 975 995 982 DK 0 0 0 0 0 Jon Peck Senior Software Engineer, IBM [hidden email] 312-651-3435 From: John F Hall <[hidden email]> To: [hidden email] Date: 11/27/2010 02:27 AM Subject: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) Sent by: "SPSSX(r) Discussion" <[hidden email]> In SPSS 15 there was a GUI menu: Analyze > Tables > Tables of Frequencies which could produce this:
This menu has disappeared from 18, but the
syntax still works: all I can find in the GUI for 18 is:
. . . which can only produce this:
or this:
|
I don’t know if the behavior has changed in 19 but in earlier versions, the GUI will only let you do this provided that all variables in the set have identical value labels. From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jon K Peck All you need to do to get the table of frequencies layout is to drag your categorical variables to the columns and then drop the Category Position control in the bottom right and choose Column Labels in Row.
This menu has disappeared from 18, but the syntax still works: all I can find in the GUI for 18 is: . . . which can only produce this:
or this:
|
In reply to this post by Jon K Peck
Jon, ViAnn
Thanks for this on Thanksgiving weekend. It's because I only have value labels on the first variable in the set, a habit dating back to syntax many years before the GUI. PS Nothing to do with SPSS, but the British billionaire turkey grower Bernard Matthews (who started with 6 eggs and with no money) died this weekend: quite ironic, don't you think? John Hall [hidden email] http://surveyresearch.weebly.com ----- Original Message ----- From: Jon K Peck To: [hidden email] Sent: Saturday, November 27, 2010 3:39 PM Subject: Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15) All you need to do to get the table of frequencies layout is to drag your categorical variables to the columns and then drop the Category Position control in the bottom right and choose Column Labels in Row. In syntax, using 1991 GSS as an example CTABLES /TABLE BY hlth1 + hlth2+hlth3+hlth4+hlth5 /CLABELS COLLABELS=OPPOSITE. The key is the last subcommand. The generated table is copied below (as plain text :-)) There is a restriction in the gui that the value label sets must be the same for all the variables when doing this. Otherwise it would be impossible to label the rows correctly. Ill Enough to Go to a Doctor Counselling for Mental Problems Infertility, Unable to Have a Baby Drinking Problem Illegal Drugs (Marijuana, Cocaine) Count Count Count Count Count Yes 559 58 35 17 30 No 454 955 975 995 982 DK 0 0 0 0 0 Jon Peck Senior Software Engineer, IBM [hidden email] 312-651-3435 From: John F Hall <[hidden email]> To: [hidden email] Date: 11/27/2010 02:27 AM Subject: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) Sent by: "SPSSX(r) Discussion" <[hidden email]> In SPSS 15 there was a GUI menu: Analyze > Tables > Tables of Frequencies which could produce this: Q4: (col 16)Q4: (col 17)Q4: (col 18)Q4: (col 19)Q4: (col 20) Count CountCountCountCount 1 1051 2 191092 3 11446 4 7219 5 6721637 6 11 . . .and produced automatic syntax: TABLES /FORMAT BLANK MISSING('.') /TABLES (LABELS) BY ( v16 + v17 + v18 + v19 + v20 ) /STATISTICS COUNT ((F5.0) 'Count' ) . This menu has disappeared from 18, but the syntax still works: all I can find in the GUI for 18 is: Analyze > Tables > Custom Tables . . . which can only produce this: v16v17v18v19v20 TypingWord- processSocial statisticsSurvey analysisOther6TypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOther CountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCount 105191106911094770246221000196000037 or this: Count v16 Typing 105 Word- process 19 Social statistics 11 Survey analysis 0 Other 6 6 9 v17 Typing 1 Word- process 109 Social statistics 4 Survey analysis 7 Other 7 v18 Typing 0 Word- process 2 Social statistics 46 Survey analysis 2 Other 21 v19 Typing 0 Word- process 0 Social statistics 0 Survey analysis 19 Other 6 v20 Typing 0 Word- process 0 Social statistics 0 Survey analysis 0 Other 37 I've tried everything I can think of (including editing the pivot table) to get the correct format, but so far woithout success. Is there any way I can get the first table from 18 via the GUI without using scripts, micros etc? This is for inclusion in a tutorial on multiple response for nervous beginners, not a demo for experts. The syntax is too complex for them to understand at this point in the course. John Hall [hidden email] http://surveyresearch.weebly.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 |
In reply to this post by John F Hall
It was the last button "Category positions" that threw me: I missed it
completely and it's not very clear what it does. When I went back to the data editor from my previous efforts, SPSS had added value labels to v17 to v20 which weren't there before. I would have preferred a prompt asking me if this is what I wanted to do. Many users of my site are still on 15 or even earlier. The table is fine. The data are from 1990 - 92 waves of students on my postgrad Survey Analysis Workshop and represent previous training or experience in the five areas mentioned (v16 to v20 are the same as Typing to other: 6 = None of these) I suspect the answers would be very different today! v16 v17 v18 v19 v20 Count Count Count Count Count Typing 105 1 0 0 0 Word- process 19 109 2 0 0 Social statistics 11 4 46 0 0 Survey analysis 0 7 2 19 0 Other 6 7 21 6 37 6 9 0 0 0 0 I can now finish the tutorial and upload it to the site. Again, many thanks, especially on a Saturday. John Hall [hidden email] http://surveyresearch.weebly.com ----- Original Message ----- From: John F Hall To: Jon K Peck ; [hidden email] ; ViAnn Beadle Cc: Bruce Weaver Sent: Saturday, November 27, 2010 4:51 PM Subject: Re: Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15) Jon, ViAnn Thanks for this on Thanksgiving weekend. It's because I only have value labels on the first variable in the set, a habit dating back to syntax many years before the GUI. PS Nothing to do with SPSS, but the British billionaire turkey grower Bernard Matthews (who started with 6 eggs and with no money) died this weekend: quite ironic, don't you think? John Hall [hidden email] http://surveyresearch.weebly.com ----- Original Message ----- From: Jon K Peck To: [hidden email] Sent: Saturday, November 27, 2010 3:39 PM Subject: Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15) All you need to do to get the table of frequencies layout is to drag your categorical variables to the columns and then drop the Category Position control in the bottom right and choose Column Labels in Row. In syntax, using 1991 GSS as an example CTABLES /TABLE BY hlth1 + hlth2+hlth3+hlth4+hlth5 /CLABELS COLLABELS=OPPOSITE. The key is the last subcommand. The generated table is copied below (as plain text :-)) There is a restriction in the gui that the value label sets must be the same for all the variables when doing this. Otherwise it would be impossible to label the rows correctly. Ill Enough to Go to a Doctor Counselling for Mental Problems Infertility, Unable to Have a Baby Drinking Problem Illegal Drugs (Marijuana, Cocaine) Count Count Count Count Count Yes 559 58 35 17 30 No 454 955 975 995 982 DK 0 0 0 0 0 Jon Peck Senior Software Engineer, IBM [hidden email] 312-651-3435 From: John F Hall <[hidden email]> To: [hidden email] Date: 11/27/2010 02:27 AM Subject: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) Sent by: "SPSSX(r) Discussion" <[hidden email]> In SPSS 15 there was a GUI menu: Analyze > Tables > Tables of Frequencies which could produce this: Q4: (col 16)Q4: (col 17)Q4: (col 18)Q4: (col 19)Q4: (col 20) Count CountCountCountCount 1 1051 2 191092 3 11446 4 7219 5 6721637 6 11 . . .and produced automatic syntax: TABLES /FORMAT BLANK MISSING('.') /TABLES (LABELS) BY ( v16 + v17 + v18 + v19 + v20 ) /STATISTICS COUNT ((F5.0) 'Count' ) . This menu has disappeared from 18, but the syntax still works: all I can find in the GUI for 18 is: Analyze > Tables > Custom Tables . . . which can only produce this: v16v17v18v19v20 TypingWord- processSocial statisticsSurvey analysisOther6TypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOther CountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCount 105191106911094770246221000196000037 or this: Count v16 Typing 105 Word- process 19 Social statistics 11 Survey analysis 0 Other 6 6 9 v17 Typing 1 Word- process 109 Social statistics 4 Survey analysis 7 Other 7 v18 Typing 0 Word- process 2 Social statistics 46 Survey analysis 2 Other 21 v19 Typing 0 Word- process 0 Social statistics 0 Survey analysis 19 Other 6 v20 Typing 0 Word- process 0 Social statistics 0 Survey analysis 0 Other 37 I've tried everything I can think of (including editing the pivot table) to get the correct format, but so far woithout success. Is there any way I can get the first table from 18 via the GUI without using scripts, micros etc? This is for inclusion in a tutorial on multiple response for nervous beginners, not a demo for experts. The syntax is too complex for them to understand at this point in the course. John Hall [hidden email] http://surveyresearch.weebly.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 |
In reply to this post by John F Hall
I'm trying to do justice to the GUI, which I find quicker and easier than
syntax for some tasks, and say so to students. A particularly useful one I found last week was Data > Define Variable Properties, not for entering stuff, but as a check on what's in the file after it's been built up from scratch with raw data using syntax only (DATA LIST, MISSING VALUES, VARIABLE LABELS and VALUE LABELS) All you need to know about each variable in turn, including a frequency count! (See pp 4-5 of http://surveyresearch.weebly.com/uploads/2/9/9/8/2998485/2.1.2.6__checking_your_file_contents_-_nominal_and_ordinal_variables.doc on the Block 2 page http://surveyresearch.weebly.com/block-2-analysing-one-variable.html) I now have around 400 pages of tutorials, most of which use 18, but there is still a chunk based on 15 in the section on COUNT and COMPUTE, which also includes a bit on RECODE. (See: http://surveyresearch.weebly.com/51-introduction-to-count-and-compute.html) So far there isn't a single equation! Incidentally, does IBM/SPSS have shares in the manufacturers of cyan ink? This colour is consumed at least twice as fast as yellow and magenta when printing up. John Hall [hidden email] http://surveyresearch.weebly.com ----- Original Message ----- From: Jon K Peck To: John F Hall Cc: ViAnn Beadle Sent: Saturday, November 27, 2010 5:04 PM Subject: Re: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) In syntax, the restriction is weaker. Only if there is an actual conflict in the value labels - different labels for the same variable, is the table stopped. Labeling just the first variable is no problem in syntax. Jon Peck Senior Software Engineer, IBM [hidden email] 312-651-3435 From: John F Hall <[hidden email]> To: [hidden email] Date: 11/27/2010 08:55 AM Subject: Re: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) Sent by: "SPSSX(r) Discussion" <[hidden email]> Jon, ViAnn Thanks for this on Thanksgiving weekend. It's because I only have value labels on the first variable in the set, a habit dating back to syntax many years before the GUI. PS Nothing to do with SPSS, but the British billionaire turkey grower Bernard Matthews (who started with 6 eggs and with no money) died this weekend: quite ironic, don't you think? John Hall [hidden email] http://surveyresearch.weebly.com ----- Original Message ----- From: Jon K Peck To: [hidden email] Sent: Saturday, November 27, 2010 3:39 PM Subject: Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15) All you need to do to get the table of frequencies layout is to drag your categorical variables to the columns and then drop the Category Position control in the bottom right and choose Column Labels in Row. In syntax, using 1991 GSS as an example CTABLES /TABLE BY hlth1 + hlth2+hlth3+hlth4+hlth5 /CLABELS COLLABELS=OPPOSITE. The key is the last subcommand. The generated table is copied below (as plain text :-)) There is a restriction in the gui that the value label sets must be the same for all the variables when doing this. Otherwise it would be impossible to label the rows correctly. Ill Enough to Go to a Doctor Counselling for Mental Problems Infertility, Unable to Have a Baby Drinking Problem Illegal Drugs (Marijuana, Cocaine) Count Count Count Count Count Yes 559 58 35 17 30 No 454 955 975 995 982 DK 0 0 0 0 0 Jon Peck Senior Software Engineer, IBM [hidden email] 312-651-3435 From: John F Hall <[hidden email]> To: [hidden email] Date: 11/27/2010 02:27 AM Subject: [SPSSX-L] Problem producing summary tables of frequencies from GUI in 18 (works in 15) Sent by: "SPSSX(r) Discussion" <[hidden email]> In SPSS 15 there was a GUI menu: Analyze > Tables > Tables of Frequencies which could produce this: Q4: (col 16)Q4: (col 17)Q4: (col 18)Q4: (col 19)Q4: (col 20) Count CountCountCountCount 1 1051 2 191092 3 11446 4 7219 5 6721637 6 11 . . .and produced automatic syntax: TABLES /FORMAT BLANK MISSING('.') /TABLES (LABELS) BY ( v16 + v17 + v18 + v19 + v20 ) /STATISTICS COUNT ((F5.0) 'Count' ) . This menu has disappeared from 18, but the syntax still works: all I can find in the GUI for 18 is: Analyze > Tables > Custom Tables . . . which can only produce this: v16v17v18v19v20 TypingWord- processSocial statisticsSurvey analysisOther6TypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOtherTypingWord- processSocial statisticsSurvey analysisOther CountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCountCount 105191106911094770246221000196000037 or this: Count v16 Typing 105 Word- process 19 Social statistics 11 Survey analysis 0 Other 6 6 9 v17 Typing 1 Word- process 109 Social statistics 4 Survey analysis 7 Other 7 v18 Typing 0 Word- process 2 Social statistics 46 Survey analysis 2 Other 21 v19 Typing 0 Word- process 0 Social statistics 0 Survey analysis 19 Other 6 v20 Typing 0 Word- process 0 Social statistics 0 Survey analysis 0 Other 37 I've tried everything I can think of (including editing the pivot table) to get the correct format, but so far woithout success. Is there any way I can get the first table from 18 via the GUI without using scripts, micros etc? This is for inclusion in a tutorial on multiple response for nervous beginners, not a demo for experts. The syntax is too complex for them to understand at this point in the course. John Hall [hidden email] http://surveyresearch.weebly.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 John F Hall
Apologies to anyone who can't read RTF messages,
but here's the table as it should be, or rather as copied from the viewer.
It doesn't copy into plain text.
|
Free forum by Nabble | Edit this page |