topic Re: Converting .XPT to SAS Datasets in SAS Programming

Converting .XPT to SAS Datasets

mounikag — Tue, 17 Aug 2021 00:09:35 GMT

Hi All,

I have a XPt file where iam trying to convert them into sas datasets by using below code but it throwing an error in SAS log. Could you please provide your thoughts on this.

libname in xport "C:Desktop\SAS1\data.xpt";
proc copy inlib=in outlib=work;
run;
proc cimport library=work infile="C:Desktop\SAS1\data.xpt";
run;

SAS LOG ERROR:

ERROR: The transport file was created in the encoding utf-8. This session encoding, wlatin1, can read and create transport files
in the encoding, wlatin1. Data not imported.

Thanks,

Mounika

Re: Converting .XPT to SAS Datasets

ChrisNZ — Tue, 17 Aug 2021 03:15:58 GMT

The message is pretty clear. You might have unicode characters in the data sets, which your current SAS session cannot read because it uses encoding wlatin1.

SAS your SAS session with encoding UTF-8 to read these tables. Either:

At SAS invocation add the option, -encoding utf-8.
Add the system option to the SAS configuration file, ENCODING=UTF-8.

Re: Converting .XPT to SAS Datasets

Ksharp — Tue, 17 Aug 2021 13:18:12 GMT

Re: Converting .XPT to SAS Datasets

mounikag — Tue, 17 Aug 2021 19:48:09 GMT

Thanks for the reply. I tried using your method by opening with SAS 9.4 unicode and tried running the above program but its throwing an error as below:

WARNING: No data is available.

Please suggest on this

Re: Converting .XPT to SAS Datasets

mounikag — Tue, 17 Aug 2021 19:59:44 GMT

HI Chrisnz,

Thanks for the reply and I tried using ENCODING=UTF-8 but it didnt worked

Re: Converting .XPT to SAS Datasets

ChrisNZ — Tue, 17 Aug 2021 21:49:44 GMT

@Ksharp wrote:

Some lucky souls still have SAS on their desktop rather than the dreadful EG? So jealous!

Re: Converting .XPT to SAS Datasets

ChrisNZ — Tue, 17 Aug 2021 21:52:16 GMT

Please suggest on this

Please show us the full log report.

Re: Converting .XPT to SAS Datasets

mounikag — Tue, 17 Aug 2021 22:18:36 GMT

Thanks Chrisnz and Ksharp for your time to answer my question .

Issue got resolved with autocall macro called

%XPT2LOC
: It createdv SAS datasets