Is this possible in SPSS? MULT RESPONSE PROBLEM

[Eugenio Grant]

Is this possible on SPSS



Hi I have a DataBase that has a report of Problems presented by cars, where
each case is a report for every dealer.



This is a simplified version of how the data looks like.(In reality the car
variable goes up to car30 and 1500 dealers)




Dealer

car1

prob1

prob2

car2

prob3

prob4


1

Honda

Door

Engine

Hummer

Pump

.


2

Toyota

Susp

.

VW

Brakes

Tires


3

Mitsub

Paint

Engine

.

.

.


4

Subaru

Interior

.

Honda

Susp

.


5

Honda

Susp

Bumper

Toyota

Engine

Paint



I know I can have a Mult Response per problem (Set of prob1 to prob4), but
how can I get a Mult Response of problems per car, So I can display the
occurrence of problems for Honda, Toyota, and so on.



Regards,

[Beadle, ViAnn]

Hard to tell what your data look like here but if on one record you have a repeating data set for each car which is car name, defect type, and number of defects for that type, you are better off restructuring the file from wide to narrow (VARSTOCASE) so that each record is a car x defect and then you can get simple sums by car. Your unit of analysis is not a dealer but a car.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Eugenio Grant
Sent: Thursday, February 08, 2007 9:39 AM
To: [hidden email]
Subject: Is this possible in SPSS? MULT RESPONSE PROBLEM

Is this possible on SPSS



Hi I have a DataBase that has a report of Problems presented by cars, where
each case is a report for every dealer.



This is a simplified version of how the data looks like.(In reality the car
variable goes up to car30 and 1500 dealers)




Dealer

car1

prob1

prob2

car2

prob3

prob4


1

Honda

Door

Engine

Hummer

Pump

.


2

Toyota

Susp

.

VW

Brakes

Tires


3

Mitsub

Paint

Engine

.

.

.


4

Subaru

Interior

.

Honda

Susp

.


5

Honda

Susp

Bumper

Toyota

Engine

Paint



I know I can have a Mult Response per problem (Set of prob1 to prob4), but
how can I get a Mult Response of problems per car, So I can display the
occurrence of problems for Honda, Toyota, and so on.



Regards,

[King Douglas]

Using SPSS 15.  Thought I'd ask you listers first...asking way late in the game about something very basic.

  In earlier versions, to "GO TO" a variable you can click on the variable list icon (the spreadsheet column with an adjacent question mark), then type the first few letters of the variable of interest, which will bring up the next variable with those letters.

  In SPSS 15, that function isn't available.  I guess I'm overlooking something basic.

  Any ideas?

  Very humbly,

  Thanks,

  King Dougls
  American Airlines Customer Reserch

[Melissa Ives]

This is a problem that has prevented our group from using SPSS 15 since
we depend on this function working.  We have reported it to SPSS, but so
far it has been considered low priority since not many have
noticed/requested it.  PLEASE send this in your request to get this
corrected and maybe we'll see it in the next patch!

Melissa
The bubbling brook would lose its song if you removed the rocks.


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
King Douglas
Sent: Thursday, February 08, 2007 10:39 AM
To: [hidden email]
Subject: [SPSSX-L] V15 problem with variable drop down list?

Using SPSS 15.  Thought I'd ask you listers first...asking way late in
the game about something very basic.

  In earlier versions, to "GO TO" a variable you can click on the
variable list icon (the spreadsheet column with an adjacent question
mark), then type the first few letters of the variable of interest,
which will bring up the next variable with those letters.

  In SPSS 15, that function isn't available.  I guess I'm overlooking
something basic.

  Any ideas?

  Very humbly,

  Thanks,

  King Dougls
  American Airlines Customer Reserch


PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

[Beadle, ViAnn]

It wasn't in 14 either. I think it disappeared with the availability to hide variables in the data editor data window.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of King Douglas
Sent: Thursday, February 08, 2007 10:39 AM
To: [hidden email]
Subject: V15 problem with variable drop down list?

Using SPSS 15.  Thought I'd ask you listers first...asking way late in the game about something very basic.

  In earlier versions, to "GO TO" a variable you can click on the variable list icon (the spreadsheet column with an adjacent question mark), then type the first few letters of the variable of interest, which will bring up the next variable with those letters.

  In SPSS 15, that function isn't available.  I guess I'm overlooking something basic.

  Any ideas?

  Very humbly,

  Thanks,

  King Dougls
  American Airlines Customer Reserch

[Richard Ristow]

At 10:38 AM 2/8/2007, Eugenio Grant wrote:

>I have a DataBase that has a report of Problems presented by cars,
>where
>each case is a report for every dealer.
>
>This is a simplified version of how the data looks like.

At 11:05 AM 2/8/2007, Beadle, ViAnn wrote:

>Hard to tell what your data look like here.

It sure is. But the problem appears to be extra double newlines. (We
get posted data like that fairly often. I wonder why it happens?)

I'm not addressing the posted question, but see if responding is easier
with the data rearranged like this:

Dealer   car1     prob1     prob2      car2      prob3     prob4
1       Honda     Door      Engine     Hummer    Pump      .
2       Toyota    Susp      .          VW        Brakes    Tires
3       Mitsub    Paint     Engine     .         .         .
4       Subar     Interior  .          Honda     Susp      .
5       Honda     Susp      Bumper     Toyota    Engine    Paint

>(In reality the car variable goes up to car30 and 1500 dealers)

[Kylie Lange]

Actually this feature is indeed in version 14 and works as King
described it (though obviously that doesn't help with version 15!). It's
the same dialogue box that you get from the Utilities > Variables menu.

Kylie.



On 9/02/2007 3:31 AM, Beadle, ViAnn wrote:

> It wasn't in 14 either. I think it disappeared with the availability to hide variables in the data editor data window.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of King Douglas
> Sent: Thursday, February 08, 2007 10:39 AM
> To: [hidden email]
> Subject: V15 problem with variable drop down list?
>
> Using SPSS 15.  Thought I'd ask you listers first...asking way late in the game about something very basic.
>
>   In earlier versions, to "GO TO" a variable you can click on the variable list icon (the spreadsheet column with an adjacent question mark), then type the first few letters of the variable of interest, which will bring up the next variable with those letters.
>
>   In SPSS 15, that function isn't available.  I guess I'm overlooking something basic.
>
>   Any ideas?
>
>   Very humbly,
>
>   Thanks,
>
>   King Dougls
>   American Airlines Customer Reserch
>

[Richard Ristow]

At 10:38 AM 2/8/2007, Eugenio Grant wrote:

>I have a DataBase that has a report of Problems presented by cars,
>where each case is a report for every dealer.
>
>I know I can have a Mult Response per problem (Set of prob1 to prob4),
>but how can I get a Mult Response of problems per car, So I can
>display the occurrence of problems for Honda, Toyota, and so on.

See if you like this: two CASESTOVARS, followed by CROSSTABS. (I don't
see how to do it with on CASESTOVARS, at least not from the menus.) All
commands except LISTs are clicked up from the menus. Sorry about lines
so long they wrap. SPSS 15 draft output.

LIST.

List
|-----------------------------|---------------------------|
|Output Created               |09-FEB-2007 00:02:19       |
|-----------------------------|---------------------------|
Dealer car1     prob1    prob2    car2     prob3    prob4

     1  Honda    Door     Engine   Hummer   Pump     .
     2  Toyota   Susp     .        VW       Brakes   Tires
     3  Mitsub   Paint    Engine   .        .        .
     4  Subar    Interior .        Honda    Susp     .
     5  Honda    Susp     Bumper   Toyota   Engine   Paint

Number of cases read:  5    Number of cases listed:  5


VARSTOCASES  /MAKE Car FROM car1 car2
  /MAKE Problem1 FROM prob1 prob3
  /MAKE Problem2 FROM prob2 prob4
  /INDEX = Car# "Which car, in dealer record"(2)
  /KEEP =  Dealer
  /NULL = KEEP.


Variables to Cases
|----------------------------|---------------------------|
|Output Created              |09-FEB-2007 00:06:25       |
|----------------------------|---------------------------|
Generated Variables
|--------|---------------|
|Name    |Label          |
|--------|---------------|
|Car#    |Which car, in  |
|        |dealer record  |
|--------|---------------|
|Car     |<none>         |
|Problem1|<none>         |
|Problem2|<none>         |
|--------|---------------|

Processing Statistics
|-------------|-|
|Variables In |7|
|-------------|-|
|Variables Out|5|
|-------------|-|


LIST.

List
|-----------------------------|---------------------------|
|Output Created               |09-FEB-2007 00:06:53       |
|-----------------------------|---------------------------|
Dealer Car# Car      Problem1 Problem2

     1     1 Honda    Door     Engine
     1     2 Hummer   Pump     .
     2     1 Toyota   Susp     .
     2     2 VW       Brakes   Tires
     3     1 Mitsub   Paint    Engine
     3     2 .        .        .
     4     1 Subar    Interior .
     4     2 Honda    Susp     .
     5     1 Honda    Susp     Bumper
     5     2 Toyota   Engine   Paint

Number of cases read:  10    Number of cases listed:  10


VARSTOCASES  /MAKE Problem FROM Problem1 Problem2
  /INDEX = Problem# "Which problem, for car"(2)
  /KEEP =  Dealer Car# Car
  /NULL = KEEP.


Variables to Cases
|----------------------------|---------------------------|
|Output Created              |09-FEB-2007 00:10:39       |
|----------------------------|---------------------------|
Generated Variables
|--------|---------------|
|Name    |Label          |
|--------|---------------|
|Problem#|Which problem, |
|        |for car        |
|--------|---------------|
|Problem |<none>         |
|--------|---------------|

Processing Statistics
|-------------|-|
|Variables In |5|
|-------------|-|
|Variables Out|5|
|-------------|-|


LIST.

List
|-----------------------------|---------------------------|
|Output Created               |09-FEB-2007 00:10:39       |
|-----------------------------|---------------------------|
Dealer Car# Car      Problem# Problem

     1     1 Honda         1   Door
     1     1 Honda         2   Engine
     1     2 Hummer        1   Pump
     1     2 Hummer        2   .
     2     1 Toyota        1   Susp
     2     1 Toyota        2   .
     2     2 VW            1   Brakes
     2     2 VW            2   Tires
     3     1 Mitsub        1   Paint
     3     1 Mitsub        2   Engine
     3     2 .             1   .
     3     2 .             2   .
     4     1 Subar         1   Interior
     4     1 Subar         2   .
     4     2 Honda         1   Susp
     4     2 Honda         2   .
     5     1 Honda         1   Susp
     5     1 Honda         2   Bumper
     5     2 Toyota        1   Engine
     5     2 Toyota        2   Paint

Number of cases read:  20    Number of cases listed:  20


CROSSTABS
   /TABLES=Car  BY Problem
   /FORMAT= AVALUE TABLES
   /CELLS= COUNT
   /COUNT ROUND CELL .


Crosstabs
|-----------------------------|---------------------------|
|Output Created               |09-FEB-2007 00:11:30       |
|-----------------------------|---------------------------|
Case Processing Summary [suppressed]

Car * Problem Crosstabulation
Count
|----|------|----------------------------------------------------------|-----|
|    |      |Problem
|Total|
|    |
|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |
|.|Brakes|Bumper|Door|Engine|Interior|Paint|Pump|Susp|Tires|.    |
|----|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|Car
|.     |2|0     |0     |0   |0     |0       |0    |0   |0   |0    |2
|
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |Honda
|1|0     |1     |1   |1     |0       |0    |0   |2   |0    |6    |
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |Hummer|1|0     |0     |0   |0     |0       |0    |1   |0   |0
|2    |
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |Mitsub|0|0     |0     |0   |1     |0       |1    |0   |0   |0
|2    |
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |Subar
|1|0     |0     |0   |0     |1       |0    |0   |0   |0    |2    |
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |Toyota|1|0     |0     |0   |1     |0       |1    |0   |1   |0
|4    |
|
|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|    |VW    |0|1     |0     |0   |0     |0       |0    |0   |0   |1
|2    |
|----|------|-|------|------|----|------|--------|-----|----|----|-----|-----|
|Total      |6|1     |1     |1   |3     |1       |2    |1   |3   |1
|20   |
|-----------|-|------|------|----|------|--------|-----|----|----|-----|-----|

=================================
APPENDIX: Test data, from posting
=================================
*  ........   Test data, reformatted from posting   ......... .

DATA LIST LIST/
   Dealer(F3) car1     prob1    prob2    car2     prob3    prob4 (6A8).
BEGIN DATA
    1         Honda    Door     Engine   Hummer   Pump     .
    2         Toyota   Susp     .        VW       Brakes   Tires
    3         Mitsub   Paint    Engine   .        .        .
    4         Subar    Interior .        Honda    Susp     .
    5         Honda    Susp     Bumper   Toyota   Engine   Paint
END DATA.