Issue in creating xpt files

[sampath]

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 · Accepted solution]

For the first, see

1528 - ERROR: The character variable XXX has too long a value for the SASV5XPTengine.

For the second,

14181 - XPORT engine does not support SORTEDBY operations. SORTEDBY informationcannot be copied

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

[sampath]

Thank you very much. Your suggestions were very helpful.

[zahirraihan]

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

[ifendo]

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

http://support.sas.com/techsup/notes/v8/14/181.html