Error in converting Transport file back into SAS dataset

[rao]

Hi

I am getting following error message.

what I did

I created a SAS Transport file by using "XPORT" engine and PROC COPY.
Then I moved the xxxx.xpt file into my company internal web site. Later
I just down loaded the xxx.xpt file. Strated converting into SAS
dataset. Iam unable to convert the xpt file back into SAS dataset.

The error message


5 libname saslib 'C:\coder\import\';
NOTE: Libref SASLIB was successfully assigned as follows:
Engine: V8
Physical Name: C:\coder\import
5 ! /*output*/
6 libname pear xport 'C:\coder\bnfcode.xpt';
NOTE: Libref PEAR was successfully assigned as follows:
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
6 ! /*input*/
7 proc copy in=pear out=saslib;
8 RUN;

NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used:
real time 1.18 seconds
cpu time 0.52 seconds

NOTE: The SAS System stopped processing this step because of errors.


If you faced this kind of error in the past, please let me know

Thanks for your help

Rao

[rao]

Hi

L1DCODE is a column name in the BNFCODE dataset. The funny thing is if
i convert the BNFCODE sas data set into BNFCODE.XPT and convert into
sas dataset immidiatly then it works file. But if i upload the .xpt
file into my company internal site and download back, and convet into
SAS datasets . It is giving error message.

One more thing I tried with your option "SELECT", still iam getting
following message

43 libname saslib 'C:\coder\import\';
NOTE: Libref SASLIB was successfully assigned as follows:
Engine: V8
Physical Name: C:\coder\import
43 ! /*output*/
44 libname pear xport 'C:\coder\bnfcode.xpt';
NOTE: Libref PEAR was successfully assigned as follows:
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
44 ! /*input*/
45
46 proc copy in=pear out=saslib ;
47 select BNFCODE;
48 RUN;

NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used:
real time 12.02 seconds
cpu time 0.53 seconds

NOTE: The SAS System stopped processing this step because of errors.


Thanks for your help. If you have any other idea let me know
Rao

[Stéphane Colas]

Rao,

What is L1DCODE for you ?

could i suggest you to specify the data that you want to transform, perhaps have
you more than one xoprt file into PEAR ?

proc copy in=pear out=saslib;
selec BNFCODE ;
RUN;

Post by rao
Hi
I am getting following error message.
what I did
I created a SAS Transport file by using "XPORT" engine and PROC COPY.
Then I moved the xxxx.xpt file into my company internal web site. Later
I just down loaded the xxx.xpt file. Strated converting into SAS
dataset. Iam unable to convert the xpt file back into SAS dataset.
The error message
5 libname saslib 'C:\coder\import\';
Engine: V8
Physical Name: C:\coder\import
5 ! /*output*/
6 libname pear xport 'C:\coder\bnfcode.xpt';
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
6 ! /*input*/
7 proc copy in=pear out=saslib;
8 RUN;
NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
real time 1.18 seconds
cpu time 0.52 seconds
NOTE: The SAS System stopped processing this step because of errors.
If you faced this kind of error in the past, please let me know
Thanks for your help
Rao

[Stéphane Colas]

Is the SAS version the same between you and you company ?

Stéphane.

Post by rao
Hi
L1DCODE is a column name in the BNFCODE dataset. The funny thing is if
i convert the BNFCODE sas data set into BNFCODE.XPT and convert into
sas dataset immidiatly then it works file. But if i upload the .xpt
file into my company internal site and download back, and convet into
SAS datasets . It is giving error message.
One more thing I tried with your option "SELECT", still iam getting
following message
43 libname saslib 'C:\coder\import\';
Engine: V8
Physical Name: C:\coder\import
43 ! /*output*/
44 libname pear xport 'C:\coder\bnfcode.xpt';
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
44 ! /*input*/
45
46 proc copy in=pear out=saslib ;
47 select BNFCODE;
48 RUN;
NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
real time 12.02 seconds
cpu time 0.53 seconds
NOTE: The SAS System stopped processing this step because of errors.
Thanks for your help. If you have any other idea let me know
Rao

[rao]

Hi Stephane

Iam using SAS8.2 version. When even I will create the SAS .XPT file,
Iam indicating V6 engine and renaming all the variables. The variables
lenth is less than 8. So that it creates V6 sas .xpt file. If I convert
it into sas datsets, it is working fine. But If i downloaded same .xpt
file from my company internal site then convert into sas generating
error message.

Iam giving here code which was used to create transport. But the
following code was ran version 8.2,


proc datasets lib = work nolist;
modify &bnf;
rename BODY_LEVEL_1_CODE =L1CODE
BODY_LEVEL_1_BNF =L1DCODE
BODY_LEVEL_1_TEXT =L1DTEXT
BODY_LEVEL_2_CODE =L2CODE
BODY_LEVEL_2_BNF =L2DCODE
BODY_LEVEL_2_TEXT =L2DTEXT
BODY_LEVEL_3_CODE =L3CODE
BODY_LEVEL_3_BNF =L3DCODE
BODY_LEVEL_3_TEXT =L3DTEXT
BODY_LEVEL_4_CODE =L4CODE
BODY_LEVEL_4_BNF =L4DCODE
BODY_LEVEL_4_TEXT =L4DTEXT
PREF_LEVEL_CODE =PCODE
PREF_LEVEL_BNF =DCODE
PREF_LEVEL_TEXT =PTEXT
ENC_LEVEL_CODE =ECODE
ENC_LEVEL_BNF =EDCODE
ENC_LEVEL_TEXT =EDTEXT;
quit;
run;

libname view v6 ' ';
data view.&bnf;
set &bnf;
run;

libname xptout XPORT
"/oraclin/interface/tms/sasextract/&bnf..xpt";
proc copy in=view out=xptout;
select &bnf;
run;

[David L Cassell]

Post by rao
I am getting following error message.
what I did
I created a SAS Transport file by using "XPORT" engine and PROC COPY.
Then I moved the xxxx.xpt file into my company internal web site. Later
I just down loaded the xxx.xpt file. Strated converting into SAS
dataset. Iam unable to convert the xpt file back into SAS dataset.
The error message
5 libname saslib 'C:\coder\import\';
Engine: V8
Physical Name: C:\coder\import
5 ! /*output*/
6 libname pear xport 'C:\coder\bnfcode.xpt';
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
6 ! /*input*/
7 proc copy in=pear out=saslib;
8 RUN;
NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
real time 1.18 seconds
cpu time 0.52 seconds
NOTE: The SAS System stopped processing this step because of errors.
If you faced this kind of error in the past, please let me know

How did you 'move' that transport file?
What are the OSes you started from and moved to?
What version of SAS on each?

Is it possible that you corrupted the file by 'moving' it improperly?

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement

[rao]

Hi Guys

The issue is Transfer mode. Now we changed to BINARY. It was working
fine.
Thank you for all your help

Thanks
Rao

[r***@gmail.com]

Post by rao
Hi Guys
The issue is Transfer mode. Now we changed to BINARY. It was working
fine.
Thank you for all your help
Thanks
Rao

Hello Rao,

I have similar issue converting XPT to datasets and I am having the similar error message

NOTE: Input library XPTFILES is sequential.
ERROR: Physical file does not exist, mypath/ae.xpt

Please let me know the way you were able to convert them.

Thanks

[Howard Schreier <hs AT dc-sug DOT org>]

Post by rao
Hi
I am getting following error message.
what I did
I created a SAS Transport file by using "XPORT" engine and PROC COPY.
Then I moved the xxxx.xpt file into my company internal web site. Later
I just down loaded the xxx.xpt file. Strated converting into SAS
dataset. Iam unable to convert the xpt file back into SAS dataset.
The error message
5 libname saslib 'C:\coder\import\';
Engine: V8
Physical Name: C:\coder\import
5 ! /*output*/
6 libname pear xport 'C:\coder\bnfcode.xpt';
Engine: XPORT
Physical Name: C:\coder\bnfcode.xpt
6 ! /*input*/
7 proc copy in=pear out=saslib;
8 RUN;
NOTE: Input library PEAR is sequential.
NOTE: Copying PEAR.BNFCODE to SASLIB.BNFCODE (memtype=DATA).
NOTE: BUFSIZE is not cloned when copying across different engines.
System Option for BUFSIZE was used.
ERROR: The value L1DCODE is not a valid SAS name.

^^

Notice (you must display with a monospace font) that there are 2 blanks
before the name in the ERROR message. One of course is needed to separate
words, but maybe another is actually stored in the name, and is causing the
problem. Seems unlikely.

How would the extra blank get into the name?

What kind of machine are you using locally, and what kind of machine is the
server where you stored the transport file? Exactly how did you do the
upload and download?

Post by rao
ERROR: File SASLIB.BNFCODE.DATA has not been saved because copy could
not be completed.
NOTE: Statements not processed because of errors noted above.
real time 1.18 seconds
cpu time 0.52 seconds
NOTE: The SAS System stopped processing this step because of errors.
If you faced this kind of error in the past, please let me know
Thanks for your help
Rao

[Rao Bingi]

Hi Guys

The issue is Transfer mode. Now we changed to BINARY. It was working fine.
Thank you for all your help

Thanks
Rao