Multiple response with text variables

[Allan Reese (Cefas)]

Does anyone have a quick fix for this please?  I have several variables
that contain keywords.  Each keyword can occur in any of the variables.
The task is to list all the keywords and frequencies that each occurs.
So it's the MULT RESPONSE problem, except MULT RESPONSE expects
numerical coding and the same set of values for each variable.
AUTORECODE doesn't work as it allocates codes based only on the values
found within each variable.

I've done this example using FREQUENCIES on each variable and combining
the tables by hand.  It would be more efficient and safer to automate
this.

As a related issue, is it possible to automate setting up a dummy
variable for each keyword?

ie data presented as:
V1  V2  V3
a    d   f
d    e   f
d    a   c
c    e   d
etc

Want
V1  V2  V3  Va  Vc  Vd  Ve  Vf
a    d   f   1   0   1   0   1
d    e   f   0   0   1   1   1
d    a   c   1   1   1   0   0
c    e   d   0   1   1   1   0

TIA
Allan


***********************************************************************************
This email and any attachments are intended for the named recipient only.  Its unauthorised use, distribution, disclosure, storage or copying is not permitted.  If you have received it in error, please destroy all copies and notify the sender.  In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent.  All emails may be subject to monitoring.
***********************************************************************************

=====================
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

[ViAnn Beadle]

I think that CTABLES will handle string variables for multiple response
sets. You could probably also restructure the file using VARSTOCASES to make
each response a case and then tabulate that or at a minimum AUTORECODE and
then revert to the former structure.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Allan Reese (Cefas)
Sent: Thursday, January 07, 2010 9:21 AM
To: [hidden email]
Subject: Multiple response with text variables

Does anyone have a quick fix for this please?  I have several variables that
contain keywords.  Each keyword can occur in any of the variables.
The task is to list all the keywords and frequencies that each occurs.
So it's the MULT RESPONSE problem, except MULT RESPONSE expects numerical
coding and the same set of values for each variable.
AUTORECODE doesn't work as it allocates codes based only on the values found
within each variable.

I've done this example using FREQUENCIES on each variable and combining the
tables by hand.  It would be more efficient and safer to automate this.

As a related issue, is it possible to automate setting up a dummy variable
for each keyword?

ie data presented as:
V1  V2  V3
a    d   f
d    e   f
d    a   c
c    e   d
etc

Want
V1  V2  V3  Va  Vc  Vd  Ve  Vf
a    d   f   1   0   1   0   1
d    e   f   0   0   1   1   1
d    a   c   1   1   1   0   0
c    e   d   0   1   1   1   0

TIA
Allan


****************************************************************************
*******
This email and any attachments are intended for the named recipient only.
Its unauthorised use, distribution, disclosure, storage or copying is not
permitted.  If you have received it in error, please destroy all copies and
notify the sender.  In messages of a non-business nature, the views and
opinions expressed are the author's own and do not necessarily reflect those
of the organisation from which it is sent.  All emails may be subject to
monitoring.
****************************************************************************
*******

=====================
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

[Art Kendall]

AUTORECODE has an option to base the numeric codes based on a group of
variables so that the vlaue labels will be identical for each of the new
variables

look up /GROUP in the autorecode documentation.

Art Kendall
Social Research Consultants

Allan Reese (Cefas) wrote:

> Does anyone have a quick fix for this please?  I have several variables
> that contain keywords.  Each keyword can occur in any of the variables.
> The task is to list all the keywords and frequencies that each occurs.
> So it's the MULT RESPONSE problem, except MULT RESPONSE expects
> numerical coding and the same set of values for each variable.
> AUTORECODE doesn't work as it allocates codes based only on the values
> found within each variable.
>
> I've done this example using FREQUENCIES on each variable and combining
> the tables by hand.  It would be more efficient and safer to automate
> this.
>
> As a related issue, is it possible to automate setting up a dummy
> variable for each keyword?
>
> ie data presented as:
> V1  V2  V3
> a    d   f
> d    e   f
> d    a   c
> c    e   d
> etc
>
> Want
> V1  V2  V3  Va  Vc  Vd  Ve  Vf
> a    d   f   1   0   1   0   1
> d    e   f   0   0   1   1   1
> d    a   c   1   1   1   0   0
> c    e   d   0   1   1   1   0
>
> TIA
> Allan
>
>
> ***********************************************************************************
> This email and any attachments are intended for the named recipient only.  Its unauthorised use, distribution, disclosure, storage or copying is not permitted.  If you have received it in error, please destroy all copies and notify the sender.  In messages of a non-business nature, the views and opinions expressed are the author's own and do not necessarily reflect those of the organisation from which it is sent.  All emails may be subject to monitoring.
> ***********************************************************************************
>
> =====================
> 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

[Anthony Babinec]

At least in recent releases, Autorecode has
a checkbox "Use the same recoding scheme for all variables."
This should do what you want to do.


Tony Babinec
[hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Allan Reese (Cefas)
Sent: Thursday, January 07, 2010 10:21 AM
To: [hidden email]
Subject: Multiple response with text variables

Does anyone have a quick fix for this please?  I have several variables
that contain keywords.  Each keyword can occur in any of the variables.
The task is to list all the keywords and frequencies that each occurs.
So it's the MULT RESPONSE problem, except MULT RESPONSE expects
numerical coding and the same set of values for each variable.
AUTORECODE doesn't work as it allocates codes based only on the values
found within each variable.

I've done this example using FREQUENCIES on each variable and combining
the tables by hand.  It would be more efficient and safer to automate
this.

As a related issue, is it possible to automate setting up a dummy
variable for each keyword?

ie data presented as:
V1  V2  V3
a    d   f
d    e   f
d    a   c
c    e   d
etc

Want
V1  V2  V3  Va  Vc  Vd  Ve  Vf
a    d   f   1   0   1   0   1
d    e   f   0   0   1   1   1
d    a   c   1   1   1   0   0
c    e   d   0   1   1   1   0

TIA
Allan


****************************************************************************
*******
This email and any attachments are intended for the named recipient only.
Its unauthorised use, distribution, disclosure, storage or copying is not
permitted.  If you have received it in error, please destroy all copies and
notify the sender.  In messages of a non-business nature, the views and
opinions expressed are the author's own and do not necessarily reflect those
of the organisation from which it is sent.  All emails may be subject to
monitoring.
****************************************************************************
*******

=====================
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
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.725 / Virus Database: 270.14.128/2604 - Release Date: 01/07/10
01:35:00

=====================
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

[Allan Reese (Cefas)]

Thank you Art, /GROUP was the feature I had not noticed.  ViAnn
suggested VARTOCASES which would be another way to apply AUTORECODE, but
/GROUP does the job exactly.  The keywords are each allocated a numeric
value and MULT RESPONSE will then tabulate them.

PASW triumphs - with a little help from one's friends.
Allan


-----Original Message-----
From: Art Kendall [mailto:[hidden email]]
Sent: 07 January 2010 17:18
To: Allan Reese (Cefas)
Cc: [hidden email]
Subject: Re: [SPSSX-L] Multiple response with text variables

AUTORECODE has an option to base the numeric codes based on a group of
variables so that the vlaue labels will be identical for each of the new
variables

look up /GROUP in the autorecode documentation.

Art Kendall
Social Research Consultants

Allan Reese (Cefas) wrote:
> Does anyone have a quick fix for this please?  I have several
> variables that contain keywords.  Each keyword can occur in any of the
variables.
> The task is to list all the keywords and frequencies that each occurs.
> So it's the MULT RESPONSE problem, except MULT RESPONSE expects
> numerical coding and the same set of values for each variable.
> AUTORECODE doesn't work as it allocates codes based only on the values

> found within each variable.
>
> I've done this example using FREQUENCIES on each variable and
> combining the tables by hand.  It would be more efficient and safer to

> automate this.
>
> As a related issue, is it possible to automate setting up a dummy
> variable for each keyword?
>
> ie data presented as:
> V1  V2  V3
> a    d   f
> d    e   f
> d    a   c
> c    e   d
> etc
>
> Want
> V1  V2  V3  Va  Vc  Vd  Ve  Vf
> a    d   f   1   0   1   0   1
> d    e   f   0   0   1   1   1
> d    a   c   1   1   1   0   0
> c    e   d   0   1   1   1   0
>
> TIA
> Allan
>
>
> **********************************************************************
> ************* This email and any attachments are intended for the
> named recipient only.  Its unauthorised use, distribution, disclosure,

storage or copying is not permitted.  If you have received it in error,
please destroy all copies and notify the sender.  In messages of a
non-business nature, the views and opinions expressed are the author's
own and do not necessarily reflect those of the organisation from which
it is sent.  All emails may be subject to monitoring.
> **********************************************************************
> *************
>
> =====================
> 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