topic Re: Issue in creating xpt files in SAS Procedures

Issue in creating xpt files

sampath — Wed, 06 Mar 2013 18:22:20 GMT

Hi,

I am trying to create ae.xpt file using following code.

libname source "xxxxx\analysis data";

libname outfile xport "xxxxx\analysis data\ae.xpt";

options nofmterr nonumber nodate missing=' ' mprint formchar='|__|+|__+=|_/\<>*' nobyline centre;

proc copy in=source out=outfile;

select ae;

run;

but I am getting following error.

ERROR: The character variable AEDECOD has too long a value for the OUTFILE library.

ERROR: File OUTFILE.ae.DATA has not been saved because copy could not be completed.

Similarly I tried to create eg.xpt files using following code?

libname source "xxxxx\analysis data";

libname outfile xport "xxxxx\analysis data\eg.xpt";

options nofmterr nonumber nodate missing=' ' mprint formchar='|__|+|__+=|_/\<>*' nobyline centre;

proc copy in=source out=outfile;

select eg;

run;

Warning: Engine XPORT does not support SORTEDBY operations. SORTEDBY information cannot be

copied.

Could any one let me know how to deal with this error and warning. Is there any alternative way to create xpt fies?

Note: I used the same code for some other data sets such LB and was successfull in generating .xpt files. Issuse is only with ae and eg datasets.

Thanks in advance.

Doc_Duke — Wed, 06 Mar 2013 19:25:04 GMT

For the first, see

For the second,

Just search support.sas.com with part of the error message to find the answer to this sort of question.

sampath — Wed, 06 Mar 2013 19:59:58 GMT

Thank you very much. Your suggestions were very helpful.

zahirraihan — Tue, 14 Feb 2017 09:21:59 GMT

Given links ain't working. Could you please update the link. I've been facing the same issue.

ifendo — Tue, 28 Nov 2017 03:01:31 GMT

in case anyone have the same issue,please check the link: