topic Re: Convet XPT to SAS dataset in SAS Programming

Convet XPT to SAS dataset

vandhan — Tue, 23 May 2017 10:14:39 GMT

Wondering that I am unable to covert XPT to SAS datasets using either copy or cimport procedure.

Log says file not found.

what could be the issue here. Is there any other way to do ?

libname abc xport 'C:Source\abc.xpt' access=readonly;
proc copy inlib=abc
outlib=work;run;

proc cimport data = data_out infile='C:Source\abc.xpt';
run;
quit;

Re: Convet XPT to SAS dataset

RW9 — Tue, 23 May 2017 10:20:08 GMT

There really isn't enough information to debug here. If the log states file not found, then its likely the file isn't found. Can you get to the file via the Explorer window in SAS (actually what SAS are you using, UE for instance is all on its own image). Syntax seems fine. Also, post the whole log snippet (as text in the post).

Re: Convet XPT to SAS dataset

Kurt_Bremser — Tue, 23 May 2017 10:45:14 GMT

For posting SAS code, use the "little running man" icon. It preserves code formatting and suppresses interpretation of "smileys".

For the log, use the {i} icon. Also important so the horizontal positioning of messages is preserved.

The log of the whole code snippet will really help in interpreting what's going wrong.

Re: Convet XPT to SAS dataset

ballardw — Tue, 23 May 2017 14:53:36 GMT

@vandhan wrote:

Wondering that I am unable to covert XPT to SAS datasets using either copy or cimport procedure.

Log says file not found.

what could be the issue here. Is there any other way to do ?

libname abc xport 'C:\Source\abc.xpt' access=readonly;
proc copy inlib=abc
outlib=work;run;

proc cimport data = data_out infile='C:\Source\abc.xpt';
run;
quit;