Problem producing summary tables of frequencies from GUI in 18 (works in 15)

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem producing summary tables of frequencies from GUI in 18 (works in 15)

John F Hall
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

Count

Count

Count

Count

1

105

1

 

 

 

2

19

109

2

 

 

3

11

4

46

 

 

4

 

7

2

19

 

5

6

7

21

6

37

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:
 

v16

v17

v18

v19

v20

Typing

Word- process

Social statistics

Survey analysis

Other

6

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

105

19

11

0

6

9

1

109

4

7

7

0

2

46

2

21

0

0

0

19

6

0

0

0

0

37

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.
 
Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

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.

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
Count
Count
Count
Count
1
105
1
     
2
19
109
2
   
3
11
4
46
   
4  
7
2
19
 
5
6
7
21
6
37
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:
 

v16
v17
v18
v19
v20
Typing
Word- process
Social statistics
Survey analysis
Other
6
Typing
Word- process
Social statistics
Survey analysis
Other
Typing
Word- process
Social statistics
Survey analysis
Other
Typing
Word- process
Social statistics
Survey analysis
Other
Typing
Word- process
Social statistics
Survey analysis
Other
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
Count
105
19
11
0
6
9
1
109
4
7
7
0
2
46
2
21
0
0
0
19
6
0
0
0
0
37

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
johnfhall@...
http://surveyresearch.weebly.com

Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

ViAnn Beadle

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
Sent: Saturday, November 27, 2010 7:40 AM
To: [hidden email]
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

Count

Count

Count

Count

1

105

1

 

 

 

2

19

109

2

 

 

3

11

4

46

 

 

4

 

7

2

19

 

5

6

7

21

6

37

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:
 

v16

v17

v18

v19

v20

Typing

Word- process

Social statistics

Survey analysis

Other

6

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Typing

Word- process

Social statistics

Survey analysis

Other

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

Count

105

19

11

0

6

9

1

109

4

7

7

0

2

46

2

21

0

0

0

19

6

0

0

0

0

37

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

Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

John F Hall
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
Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

John F Hall
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
Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

John F Hall
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
Reply | Threaded
Open this post in threaded view
|

Re: Problem producing summary tables of frequencies from GUI in 18 (works in 15)

John F Hall
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.
 
 

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