topic Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code in SAS Programming

Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Tue, 08 Sep 2020 03:29:54 GMT

Hi everyone,

I'm converting SAS datasets to SAS xport(.xpt) files by using PROC COPY. Chinese characters in SAS datasets are displayed well in SAS 9.4 and SAS universal viewer, but after converted in .xpt file, they become messy code in SAS universal viewer and can't be opened in SAS 9.4.

Is there a solution to make the Chinese characters show well in .xpt file?

Any tips or suggestions are very much appreciated!

Thanks a lot in advance.

Zoe

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

SASKiwi — Tue, 08 Sep 2020 04:14:17 GMT

I suspect you will need to use PROC CPORT / CIMPORT to support the usage of DBCS character sets like Chinese.

The NLS manual should help you.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Wed, 09 Sep 2020 03:10:55 GMT

Thank you for your suggestion. I tried to use PROC CPORT, but it didn't work. And, using PROC CPORT, the .xpt file can't even be opened by SAS universal viewer.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

SASKiwi — Wed, 09 Sep 2020 03:27:40 GMT

@Zoe_Steven - I suggest you open a track with SAS Tech Support if you haven't done so already. They are in the best position to help. This will likely require investigation and tweaking of your NLS settings and running a bunch of tests. I wouldn't be surprised if the Universal Viewer simply doesn't support DBCS.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

ChrisNZ — Wed, 09 Sep 2020 04:01:51 GMT

We'd need to see your code to comment further.

Have read this paper Tips and Fixes for Cross-Environment Batch Transfer of SAS® Data and the links in it?

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Thu, 10 Sep 2020 10:23:45 GMT

@ChrisNZ , thank you for your reply.

Please see below for the code I used. I guess this is caused by incompatibility between SAS universal viewer and Chinese words in xpt files. Because when I use SAS to open the xpt file with messy codes, the SAS will run PROC COPY to convert xpt file back to SAS dataset whose chinese words look fine. BTW, there is no problem when SAS datasets with chinese words are opened by SAS universal viewer.

libname _sas_ "&saspath";
libname xptout xport "&xptpath.\adsl.xpt";

data adsl;
     set _sas_.adsl;
run;

proc copy in=work out=xptout memtype=data;
    select adsl;
run;

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Thu, 10 Sep 2020 10:28:08 GMT

@SASKiwi , thank you so much.

I guess this is caused by incompatibility between SAS universal viewer and DBCS in xpt files. Because when I use SAS to open the xpt file with messy codes, the SAS will run PROC COPY to convert xpt file back to SAS dataset whose chinese words look fine. BTW, there is no problem when SAS datasets with chinese words are opened by SAS universal viewer.

May I ask a silly question? How to open a track with SAS Tech Support? ☺

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

ChrisNZ — Thu, 10 Sep 2020 10:54:41 GMT

Send an email to SUPPORT at SAS dot COM.
Add the output from proc setinit so they have a copy of the site's license.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

SASKiwi — Thu, 10 Sep 2020 20:12:09 GMT

@Zoe_Steven - Here is the link to open a Tech Support track

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Fri, 11 Sep 2020 03:12:07 GMT

Thank you so much, got it.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Fri, 11 Sep 2020 03:15:17 GMT

Okay, thank you. I've contacted SAS SUPPORT

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Mon, 21 Sep 2020 06:16:47 GMT

This is the answer that I got from SAS support tracking:

SAS Universal Viewer supports XPT format with English data. However, data that includes Asian characters is not displayed correctly. There is no workaround for this issue.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

ChrisNZ — Mon, 21 Sep 2020 08:26:23 GMT

Thank you for the update,

If this is linked to this UNote, the issue is many years old, and "A fix for this issue is planned for a future software release." 💀

You could ask them when it is planned for.

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

Zoe_Steven — Thu, 24 Sep 2020 02:21:33 GMT

Haha, got it, thank you!

Re: Convert sas dataset to .xpt file using PROC COPY: Chinese character turns to messy code

SASKiwi — Thu, 24 Sep 2020 03:03:50 GMT

@Zoe_Steven - AFAIK, the Universal Viewer is regarded as legacy software (along with quite a lot of older SAS products) so I wouldn't be holding my breath regarding any fixes or updates. SAS has advanced a lot in NLS but legacy products stay as they are often due to lack of demand.