Help using Base SAS procedures

Issue in creating xpt files

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

Issue in creating xpt files

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.


Accepted Solutions
Solution
‎03-06-2013 02:25 PM
Trusted Advisor
Posts: 2,113

Re: Issue in creating xpt files


All Replies
Solution
‎03-06-2013 02:25 PM
Trusted Advisor
Posts: 2,113

Re: Issue in creating xpt files

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.

Contributor
Posts: 35

Re: Issue in creating xpt files

Thank you very much. Your suggestions were very helpful.

Occasional Contributor
Posts: 6

Re: Issue in creating xpt files

Given links ain't working. Could you please update the link. I've been facing the same issue.
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 1625 views
  • 0 likes
  • 3 in conversation