Date: Sun, 6 Apr 2008 10:47:56 -0500
Reply-To: "Peck, Jon" <peck@spss.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Peck, Jon" <peck@spss.com>
Subject: Re: Capitalize the First Word in the Quotation Mark
using SPSS
In-Reply-To: A<016b01c897f4$763a3640$9c00a8c0@NOTEBOOK>
Content-Type: text/plain; charset="utf-8"
Actually, if you want to construct new value label syntax with the corrected text, you can do it using the valuelabel function and appropriate index functions. This would be much easier to do with programmability, though.
HTH,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Hector Maletta
Sent: Sunday, April 06, 2008 8:42 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: [SPSSX-L] Capitalize the First Word in the Quotation Mark using SPSS
Hans,
SPSS syntax cannot do this.
Since you have tried Word, I think you may use it. I think the solution is:
Format - Change case - Sentence case.
However, each label should start at the beginning of the sentence, otherwise
this would not work. Since you need also the quotation marks and the value,
you may first copy everything in Excel, one column for the value, one for
each quotation mark, and one for the text. Then copy the text in Word, apply
Change Case in Word, copy back to Excel, finally copy from Excel to the
syntax file.
I have not tried it, and I reckon it is rather cumbersome, but it should
work.
Hector
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Hans Chen
Sent: 06 April 2008 10:09
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Capitalize the First Word in the Quotation Mark using SPSS
Dear lister(s):
My value labels look like as follows:
/Q2M1 TO Q2M3
01 "Happy With Convenient Garbage and Recycle"
02 "Always Room For Some Improvement/ Needs"
03 "Services Aren't Regular/ Not Often Enough"
04 "Garbage Sits Too Long And Ends Up All Over"
05 "A Costly Service For What Is Done"
06 "In The Winter They Should Pick Up More O"
07 "The Price Is Pretty Good For The Convenience"
08 "Need More And Better Recycling Services"
09 "Bins Overflowing"
10 "Too Many Restrictions On What And How Mu"
11 "Private Pick Up/ Excellent Service"
12 "I Live In A Good Neighborhood With Good "
13 "Furniture/ Large Pieces Sit Out Here For"
14 "High Density Are/ Need More Service/ Lit"
15 "I Am Not Sure What We Pay For It Now"
16 "I Have Seen What People In Other Parts O"
17 "I Dislike When People Misuse The System/"
18 "The Recycling Is Convenient, Good Back A"
96 "Just Satisfied/ Fair Adequate"
98 "Don't Know (DO NOT READ)"
99 "Refused (DO NOT READ)"
I would like to change them as follows: the first word in the quotation mark
in each row is capitalized. I have tried to transform the font in Microsoft
Word and Excel but failed. To change it manually would be very boring and
time-consuming. Could you tell me whether it is possible to do it using SPSS
syntax? You response will be highly appreciated.
Hans Chen
=======================================================
/Q2M1 TO Q2M3
01 "Happy with convenient garbage and recycle"
02 "Always room for some improvement/ needs"
03 "Services aren't regular/ not often enough"
04 "Garbage sits too long and ends up all over"
05 "A costly service for what is done"
06 "In the winter they should pick up more"
07 "The price is pretty good for the convenience"
08 "Need more and better recycling services"
09 "Bins overflowing"
10 "Too many restrictions on what and how mu"
11 "Private pick up/ excellent service"
12 "I live in a good neighborhood with good"
13 "Furniture/ large pieces sit out here for"
14 "High density is/ need more service/ lit"
15 "I am not sure what we pay for it now"
16 "I have seen what people in other parts o"
17 "I dislike when people misuse the system/"
18 "The recycling is convenient, good back a"
96 "Just satisfied/ fair adequate"
98 "Don't know (DO NOT READ)"
99 "Refused (DO NOT READ)"
=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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
LISTSERV@LISTSERV.UGA.EDU (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
LISTSERV@LISTSERV.UGA.EDU (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
