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.
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.
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.
Thank you very much. Your suggestions were very helpful.
in case anyone have the same issue,please check the link:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.