Re: Code Open-ended Questions using SPSS

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

Re: Code Open-ended Questions using SPSS

Hans Chen
Dear lister(s):



To code the open-end the question (verbatim) is very boring and
time-consuming.
For Example, I have some question like this:
------------------------------------------------------

Question: What is the most important thing the Canadian Government should
consider now?

Respno  Question#  Answer

0001    X1        I think the Health care is most urgent

0003    X2        Many people are losing their job

.        .                     .

.        .                     .

.        .                     .
3987    X2       More and more immigrants from all over the word make Canada
a much worse place to live
----------------------------------------------------------------------------------------------------


I have been wonder whether we can make the job a little bit easy by SPSS
syntax something like this?

Computer X1=0

If "Economy" X1=1

If "Agriculture" =2

If "Health Care" x1=3



Sincerely









Hans Chen

=====================
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: Code Open-ended Questions using SPSS

Art Kendall
try something like this untested syntax.

autorecode  variables = mystring
 /into mynumber
 /print.
recode mynumber
  (1,12,42,103,210=1)
  (2,4, 18 thru 28 =2)
  (3,5, 188 thru 199 =3)
   ...
  (17, 98, 102, 165 thru 171, 211 thru 215 = 11)
  (else=12)
   into x1.
value labels
 1 "Economy"
 2 "Agriculture"
 3 "health care"
 . . .
 11 "Gas prices"
 12 "other.
sort cases by x1 mystring.
list vars= x1 mystring.

go back and fix the recode. you may have to do this several times until
you are satisfied.

If you have more than one variable that you want to recode  the same
way, use the
   /grouped
option in autorecode
Art Kendall
Social Research Consultants




Hans Chen wrote:

> Dear lister(s):
>
>
>
> To code the open-end the question (verbatim) is very boring and
> time-consuming.
> For Example, I have some question like this:
> ------------------------------------------------------
>
> Question: What is the most important thing the Canadian Government should
> consider now?
>
> Respno  Question#  Answer
>
> 0001    X1        I think the Health care is most urgent
>
> 0003    X2        Many people are losing their job
>
> .        .                     .
>
> .        .                     .
>
> .        .                     .
> 3987    X2       More and more immigrants from all over the word make Canada
> a much worse place to live
> ----------------------------------------------------------------------------------------------------
>
>
> I have been wonder whether we can make the job a little bit easy by SPSS
> syntax something like this?
>
> Computer X1=0
>
> If "Economy" X1=1
>
> If "Agriculture" =2
>
> If "Health Care" x1=3
>
>
>
> Sincerely
>
>
>
>
>
>
>
>
>
> Hans Chen
>
> =====================
> 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
Social Research Consultants
Reply | Threaded
Open this post in threaded view
|

Re: Code Open-ended Questions using SPSS

Johnny Amora
In reply to this post by Hans Chen
There is an stand-alone software of spss called "text
analysis for surveys".  The open-ended question like
the example of Hans can be handled easily.

Cheers,

John

--- Hans Chen <[hidden email]> wrote:

> Dear lister(s):
>
>
>
> To code the open-end the question (verbatim) is very
> boring and
> time-consuming.
> For Example, I have some question like this:
>
------------------------------------------------------

>
> Question: What is the most important thing the
> Canadian Government should
> consider now?
>
> Respno  Question#  Answer
>
> 0001    X1        I think the Health care is most
> urgent
>
> 0003    X2        Many people are losing their job
>
> .        .                     .
>
> .        .                     .
>
> .        .                     .
> 3987    X2       More and more immigrants from all
> over the word make Canada
> a much worse place to live
>
----------------------------------------------------------------------------------------------------

>
>
> I have been wonder whether we can make the job a
> little bit easy by SPSS
> syntax something like this?
>
> Computer X1=0
>
> If "Economy" X1=1
>
> If "Agriculture" =2
>
> If "Health Care" x1=3
>
>
>
> Sincerely
>
>
>
>
>
>
>
>
>
> Hans Chen
>
> =====================
> 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
>



      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.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: Code Open-ended Questions using SPSS

Peck, Jon
In reply to this post by Hans Chen
Apart from using STAFS, this is a good candidate for processing with programmability regular expressions, but doing a thorough job is a lot of work - which is why there is specialized software for this.

Regards,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Hans Chen
Sent: Sunday, April 06, 2008 8:46 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Code Open-ended Questions using SPSS

Dear lister(s):



To code the open-end the question (verbatim) is very boring and
time-consuming.
For Example, I have some question like this:
------------------------------------------------------

Question: What is the most important thing the Canadian Government should
consider now?

Respno  Question#  Answer

0001    X1        I think the Health care is most urgent

0003    X2        Many people are losing their job

.        .                     .

.        .                     .

.        .                     .
3987    X2       More and more immigrants from all over the word make Canada
a much worse place to live
----------------------------------------------------------------------------------------------------


I have been wonder whether we can make the job a little bit easy by SPSS
syntax something like this?

Computer X1=0

If "Economy" X1=1

If "Agriculture" =2

If "Health Care" x1=3



Sincerely









Hans Chen

=====================
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: Code Open-ended Questions using SPSS

bgreen
In reply to this post by Hans Chen
Hans,

For this to work you would need a list of synonyms for each term, e.g
economy etc, that were mutually exclusive. I once used a DOS based
program called VB-PRO for such a task. It was freeware.

Bob

At 12:46 AM 7/04/2008, you wrote:

>Dear lister(s):
>
>
>
>To code the open-end the question (verbatim) is very boring and
>time-consuming.
>For Example, I have some question like this:
>------------------------------------------------------
>
>Question: What is the most important thing the Canadian Government should
>consider now?
>
>Respno  Question#  Answer
>
>0001    X1        I think the Health care is most urgent
>
>0003    X2        Many people are losing their job
>
>.        .                     .
>
>.        .                     .
>
>.        .                     .
>3987    X2       More and more immigrants from all over the word make Canada
>a much worse place to live
>----------------------------------------------------------------------------------------------------
>
>
>I have been wonder whether we can make the job a little bit easy by SPSS
>syntax something like this?
>
>Computer X1=0
>
>If "Economy" X1=1
>
>If "Agriculture" =2
>
>If "Health Care" x1=3
>
>
>
>Sincerely
>
>
>
>
>
>
>
>
>
>Hans Chen
>
>=====================
>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: Code Open-ended Questions using SPSS

news
I guess you mena this one :
http://www.mariapinto.es/ciberabstracts/Articulos/VBPro.htm

Another prog that might help is the German TextStat which also has an
English interface :
TextSTAT - Simple Text Analysis Tool
Concordance software for Windows, GNU/Linux and MacOS X
TextSTAT is a simple programme for the analysis of texts. It reads
ASCII/ANSI texts (in different encodings) and HTML files (directly from
the internet) and it produces word frequency lists and concordances from
these files.
http://www.niederlandistik.fu-berlin.de/textstat/software-en.html

Hope this helps
Frank Thomas

Bob Green wrote:

> Hans,
>
> For this to work you would need a list of synonyms for each term, e.g
> economy etc, that were mutually exclusive. I once used a DOS based
> program called VB-PRO for such a task. It was freeware.
>
> Bob
>
> At 12:46 AM 7/04/2008, you wrote:
>> Dear lister(s):
>>
>>
>>
>> To code the open-end the question (verbatim) is very boring and
>> time-consuming.
>> For Example, I have some question like this:
>> ------------------------------------------------------
>>
>> Question: What is the most important thing the Canadian Government
>> should
>> consider now?
>>
>> Respno  Question#  Answer
>>
>> 0001    X1        I think the Health care is most urgent
>>
>> 0003    X2        Many people are losing their job
>>
>> .        .                     .
>>
>> .        .                     .
>>
>> .        .                     .
>> 3987    X2       More and more immigrants from all over the word make
>> Canada
>> a much worse place to live
>> ----------------------------------------------------------------------------------------------------
>>
>>
>>
>> I have been wonder whether we can make the job a little bit easy by SPSS
>> syntax something like this?
>>
>> Computer X1=0
>>
>> If "Economy" X1=1
>>
>> If "Agriculture" =2
>>
>> If "Health Care" x1=3
>>
>>
>>
>> Sincerely
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hans Chen
>>
>> =====================
>> 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
>
>


--
..........................................
Dr. Frank Thomas
FTR Internet Research
93110 Rosny-sous-Bois
France

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