Nice set of tutorials

[John F Hall]

Just came across a nice set of tutorials (pdf) by Dr Daniel Boduszek (Research Criminologist and Methodologist, University of Huddersfield)  and thought I’d share them with you.  They cover a range of statistical analyses (using SPSS) and the examples are all from criminological research.

 

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

Start page:  www.surveyresearch.weebly.com/spss-without-tears.html

  

 

 

 

 

 

[Art Kendall]

Thank you.  I'll take a look.
On 4/29/2013 5:17 AM, John F Hall [via SPSSX Discussion] wrote:

Just came across a nice set of tutorials (pdf) by Dr Daniel Boduszek (Research Criminologist and Methodologist, University of Huddersfield)  and thought I’d share them with you.  They cover a range of statistical analyses (using SPSS) and the examples are all from criminological research.

 

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

Start page:  www.surveyresearch.weebly.com/spss-without-tears.html

  

 

 

 

 

 

---

If you reply to this email, your message will be added to the discussion below:

http://spssx-discussion.1045642.n5.nabble.com/Nice-set-of-tutorials-tp5719805.html

To start a new topic under SPSSX Discussion, email [hidden email]
To unsubscribe from SPSSX Discussion, click here.
NAML

[King Douglas]

Folks, 

I have an SPSS (v19) data file with an open-ended text field for respondent comments in their native language.  Before I open the file, I have to set Unicode=No if I want the Chinese (and some other) characters to be rendered correctly.  However, when I save the data file in various formats that Excel can read (e.g., CSV), the Chinese characters are rendered as some kind of machine code. 

I can copy the comment field from the SPSS data file and paste it into Excel as "Paste Special > Unicode Text," which renders the Chinese characters correctly.    

No other combinations of opening the data file (E.G., Set Unicode= Yes), and saving it in various formats yields a file in which the Chinese characters are rendered correctly...although all the other field types appear to be okay.

I suppose this is more of an Excel question than SPSS, but when the two have to play nicely together...  I've searched for an Excel solution online...no luck.

Any suggestions?

Thanks,

King Douglas

[John F Hall]

Ralph

 

Sorry about that: forgot some lists don’t like embedded links.

 

John

 

http://www.danielboduszek.com/

 

http://www.danielboduszek.com/statistical-analysis

 

 

From: [hidden email] [mailto:[hidden email]]
Sent: 29 April 2013 15:18
To: [hidden email]
Subject: Re: Nice set of tutorials

 

Would you please send me the full link to Dr. Boduszek's site? The hyperlink in your e-mail fails. Thanks. Ralph

 

In a message dated 4/29/2013 5:18:40 A.M. Eastern Daylight Time, [hidden email] writes:

Just came across a nice set of tutorials (pdf) by Dr Daniel Boduszek (Research Criminologist and Methodologist, University of Huddersfield)  and thought I’d share them with you.  They cover a range of statistical analyses (using SPSS) and the examples are all from criminological research.

 

 

John F Hall (Mr)

[Retired academic survey researcher]

 

Email:   [hidden email] 

Website: www.surveyresearch.weebly.com

Start page:  www.surveyresearch.weebly.com/spss-without-tears.html

  

 

 

 

 

 

[Jon K Peck]

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        [hidden email],
Date:        04/29/2013 02:16 PM
Subject:        [SPSSX-L] Unicode problem when saving as Excel
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Folks,

I have an SPSS (v19) data file with an open-ended text field for respondent comments in their native language.  Before I open the file, I have to set Unicode=No if I want the Chinese (and some other) characters to be rendered correctly.  However, when I save the data file in various formats that Excel can read (e.g., CSV), the Chinese characters are rendered as some kind of machine code.

>>>That is the wrong approach.  You need to set the SPSS locale to match the encoding in the text file.  Otherwise, while the characters may display correctly, they are actually coded wrong.  So when you save to Excel, and they have to be converted to Unicode (which is what Excel uses exclusively), the conversion will be wrong.  You set the locale with
SET LOCALE='locale-identifier'.
For Chinese, it depends on whether it is Traditional Chinese (Taiwan) or Simplified Chinese (PRC).  Locale identifiers vary, but you could try
zh_Hant_TW.Big5
zh_Hans_CN.GBK
There are other variations on these such as
zh_cn  for PRC and zh_tw for Taiwan.


I can copy the comment field from the SPSS data file and paste it into Excel as "Paste Special > Unicode Text," which renders the Chinese characters correctly.    

No other combinations of opening the data file (E.G., Set Unicode= Yes), and saving it in various formats yields a file in which the Chinese characters are rendered correctly...although all the other field types appear to be okay.

I suppose this is more of an Excel question than SPSS, but when the two have to play nicely together...  I've searched for an Excel solution online...no luck.

Any suggestions?

Thanks,

King Douglas

[King Douglas]

Thanks, Jon...and I understand.

Since there are multiple languages in the comment field, I suppose I'll have to split the data file by language and set the appropriate locale for each, then recombine the files after saving them in Excel.

I'll give it a shot and report back as to how it works.

Cheers,

King

---

From: Jon K Peck <[hidden email]>
To: King Douglas <[hidden email]>
Cc: [hidden email]
Sent: Mon, April 29, 2013 3:49:33 PM
Subject: Re: [SPSSX-L] Unicode problem when saving as Excel



Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        [hidden email],
Date:        04/29/2013 02:16 PM
Subject:        [SPSSX-L] Unicode problem when saving as Excel
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Folks,

I have an SPSS (v19) data file with an open-ended text field for respondent comments in their native language.  Before I open the file, I have to set Unicode=No if I want the Chinese (and some other) characters to be rendered correctly.  However, when I save the data file in various formats that Excel can read (e.g., CSV), the Chinese characters are rendered as some kind of machine code.

>>>That is the wrong approach.  You need to set the SPSS locale to match the encoding in the text file.  Otherwise, while the characters may display correctly, they are actually coded wrong.  So when you save to Excel, and they have to be converted to Unicode (which is what Excel uses exclusively), the conversion will be wrong.  You set the locale with
SET LOCALE='locale-identifier'.
For Chinese, it depends on whether it is Traditional Chinese (Taiwan) or Simplified Chinese (PRC).  Locale identifiers vary, but you could try
zh_Hant_TW.Big5
zh_Hans_CN.GBK
There are other variations on these such as
zh_cn  for PRC and zh_tw for Taiwan.


I can copy the comment field from the SPSS data file and paste it into Excel as "Paste Special > Unicode Text," which renders the Chinese characters correctly.    

No other combinations of opening the data file (E.G., Set Unicode= Yes), and saving it in various formats yields a file in which the Chinese characters are rendered correctly...although all the other field types appear to be okay.

I suppose this is more of an Excel question than SPSS, but when the two have to play nicely together...  I've searched for an Excel solution online...no luck.

Any suggestions?

Thanks,

King Douglas

[Jon K Peck]

I don't think so.  If the file already holds all the characters correctly, then it is in an encoding that by definition already works.  You just have to match that with the SPSS locale or encoding setting.  It might well be in Unicode utf-8 already.  You might try opening it in Firefox and using View > Encoding > Autodetect to see what it things the file is.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        Jon K Peck/Chicago/IBM@IBMUS,
Cc:        [hidden email]
Date:        04/29/2013 03:13 PM
Subject:        Re: [SPSSX-L] Unicode problem when saving as Excel

---

Thanks, Jon...and I understand.

Since there are multiple languages in the comment field, I suppose I'll have to split the data file by language and set the appropriate locale for each, then recombine the files after saving them in Excel.

I'll give it a shot and report back as to how it works.

Cheers,

King

---

From: Jon K Peck <[hidden email]>
To: King Douglas <[hidden email]>
Cc: [hidden email]
Sent: Mon, April 29, 2013 3:49:33 PM
Subject: Re: [SPSSX-L] Unicode problem when saving as Excel



Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        [hidden email],
Date:        04/29/2013 02:16 PM
Subject:        [SPSSX-L] Unicode problem when saving as Excel
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Folks,

I have an SPSS (v19) data file with an open-ended text field for respondent comments in their native language.  Before I open the file, I have to set Unicode=No if I want the Chinese (and some other) characters to be rendered correctly.  However, when I save the data file in various formats that Excel can read (e.g., CSV), the Chinese characters are rendered as some kind of machine code.

>>>That is the wrong approach.  You need to set the SPSS locale to match the encoding in the text file.  Otherwise, while the characters may display correctly, they are actually coded wrong.  So when you save to Excel, and they have to be converted to Unicode (which is what Excel uses exclusively), the conversion will be wrong.  You set the locale with
SET LOCALE='locale-identifier'.
For Chinese, it depends on whether it is Traditional Chinese (Taiwan) or Simplified Chinese (PRC).  Locale identifiers vary, but you could try
zh_Hant_TW.Big5
zh_Hans_CN.GBK
There are other variations on these such as
zh_cn  for PRC and zh_tw for Taiwan.


I can copy the comment field from the SPSS data file and paste it into Excel as "Paste Special > Unicode Text," which renders the Chinese characters correctly.    

No other combinations of opening the data file (E.G., Set Unicode= Yes), and saving it in various formats yields a file in which the Chinese characters are rendered correctly...although all the other field types appear to be okay.

I suppose this is more of an Excel question than SPSS, but when the two have to play nicely together...  I've searched for an Excel solution online...no luck.

Any suggestions?

Thanks,

King Douglas

[King Douglas]

Thanks again, Jon.  I'll work this out and report back to the list.

Cheers,

King

---

From: Jon K Peck <[hidden email]>
To: King Douglas <[hidden email]>
Cc: [hidden email]
Sent: Mon, April 29, 2013 4:24:12 PM
Subject: Re: [SPSSX-L] Unicode problem when saving as Excel

I don't think so.  If the file already holds all the characters correctly, then it is in an encoding that by definition already works.  You just have to match that with the SPSS locale or encoding setting.  It might well be in Unicode utf-8 already.  You might try opening it in Firefox and using View > Encoding > Autodetect to see what it things the file is.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        Jon K Peck/Chicago/IBM@IBMUS,
Cc:        [hidden email]
Date:        04/29/2013 03:13 PM
Subject:        Re: [SPSSX-L] Unicode problem when saving as Excel

---

Thanks, Jon...and I understand.

Since there are multiple languages in the comment field, I suppose I'll have to split the data file by language and set the appropriate locale for each, then recombine the files after saving them in Excel.

I'll give it a shot and report back as to how it works.

Cheers,

King

---

From: Jon K Peck <[hidden email]>
To: King Douglas <[hidden email]>
Cc: [hidden email]
Sent: Mon, April 29, 2013 3:49:33 PM
Subject: Re: [SPSSX-L] Unicode problem when saving as Excel



Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: [phone]




From:        King Douglas <[hidden email]>
To:        [hidden email],
Date:        04/29/2013 02:16 PM
Subject:        [SPSSX-L] Unicode problem when saving as Excel
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Folks,

I have an SPSS (v19) data file with an open-ended text field for respondent comments in their native language.  Before I open the file, I have to set Unicode=No if I want the Chinese (and some other) characters to be rendered correctly.  However, when I save the data file in various formats that Excel can read (e.g., CSV), the Chinese characters are rendered as some kind of machine code.

>>>That is the wrong approach.  You need to set the SPSS locale to match the encoding in the text file.  Otherwise, while the characters may display correctly, they are actually coded wrong.  So when you save to Excel, and they have to be converted to Unicode (which is what Excel uses exclusively), the conversion will be wrong.  You set the locale with
SET LOCALE='locale-identifier'.
For Chinese, it depends on whether it is Traditional Chinese (Taiwan) or Simplified Chinese (PRC).  Locale identifiers vary, but you could try
zh_Hant_TW.Big5
zh_Hans_CN.GBK
There are other variations on these such as
zh_cn  for PRC and zh_tw for Taiwan.


I can copy the comment field from the SPSS data file and paste it into Excel as "Paste Special > Unicode Text," which renders the Chinese characters correctly.    

No other combinations of opening the data file (E.G., Set Unicode= Yes), and saving it in various formats yields a file in which the Chinese characters are rendered correctly...although all the other field types appear to be okay.

I suppose this is more of an Excel question than SPSS, but when the two have to play nicely together...  I've searched for an Excel solution online...no luck.

Any suggestions?

Thanks,

King Douglas