export data problem

[Akimy]

I have used this Software (cspro5.0) about two months,then I have some problems and I hope you can help me .My questions as follows:

After the data have already typed in,when export the data to SAS date format or any other date format,the problem happened.When an Chinese open problems（like name,some have two Chinese characters,some have three Chinese characters,others maybe have four Chinese characters ） in questionnaire , export data can be a problem. A Chinese character are two bytes, but export system will mistakenly believe that a Chinese character takes up one byte, so the back of the variable data will stagger.for example , the second Variable (name) is an open Chinese question which length is 8 bytes,when export the date , the back of the variable data out of orderd.
Look forward to your response and thank you very much!

[khurshid.arshad]

Dear Akimy
See 6th message under "Feature Requests" on Board index page .

a.

[khurshid.arshad]

Dear Akimy

When you run export data please select "Unicode Output" under "Additional Option" in CSExport window. For reference see attached file.
a.

[Akimy]

Dear khurshid
Firstly ,thank you for your reply,but I still have this problem.I have already selected "Unicode Output",My problem is when export the date, the second Variable (name) which length is 8 bytes will make mistake,the first person "王一一"which have three Chinese characters, this will cause the variable (name)become 11bytes(3+3+5) actually;the second person "陈青"which have only two Chinese characters ,this will cause this variable become 10 bytes(2+2+6)...so as the picture shows the back of the variable data out of orderd and even lose some date.
Look forward to your response,thanks a lot .

Dear Akimy

When you run export data please select "Unicode Output" under "Additional Option" in CSExport window. For reference see attached file.
a.

[khurshid.arshad]

Dear Akimy

Dear Akimy why don't you export your data in comma delimited and open in excel and save it in excel format. You can Import your data from excel to SAS without any problem.
for reference see this link:
http://www.ciser.cornell.edu/faq/sas/excel2sas.shtml
a.

[Akimy]

Dear khurshid:
If I export data in comma delimited and open in excel , save it in excel format and import to SAS as you said,I will face to Unpredictable mistakes,such as Changing the attribute variables,this will influence our analysis work and results.Can I export data into SAS format without any problems above directly? Look forward to your response,thanks a lot .

Dear Akimy

Dear Akimy why don't you export your data in comma delimited and open in excel and save it in excel format. You can Import your data from excel to SAS without any problem.
for reference see this link:
http://www.ciser.cornell.edu/faq/sas/excel2sas.shtml
a.

[khurshid.arshad]

Dear Akimy

I have never used the SAS but i have found some links and PDF file for Unicode. We are working on STATA and SPSS 20 for analysis.

http://support.sas.com/kb/19/614.html
https://groups.google.com/forum/#!topic ... 7c_jD7E1sQ

a.

[Gregory Martin]

Akimy,

Another person working with Chinese data has informed me about the problems that he had reading Chinese data in SAS. I worked on making the Export Data tool Unicode compliant, but I don't have a version of SAS that reads Chinese characters properly, so it is hard for me to know how to fix the problem.

If you send me a description of the proper way to import data to SAS, then I can modify the Export Data tool to meet this need. Ideally, you could send me a script to import a numeric field, followed by an alpha, followed by a numeric. That should guarantee that the Chinese alpha field is read in properly.

gregory.martin@census.gov