topic Convert CSV to XPT in SAS Procedures

Convert CSV to XPT

cjoshi — Thu, 29 Nov 2018 05:30:42 GMT

I was able to import my CSV file into SAS (under lib WORK.nameoffile)

However, I am having issues with created a sas transport file (.xpt). I have SAS 9.4. I tried creating with the wizard, and though I can import by in with the wizard, the file is unable to be imported into JMP of SAS viewer.

I also used the proc copy code below, but am unable to get it to work.

libname source 'Work.ImportedFile';
libname xportout xport 'C:\ADA\Filename.xpt';
proc copy in=source out=xportout memtype=data; 
run;

I've gotten the following errors - source could not be assigned because libref does not exist.

Can someone point me in the right direction?

Thank you!

Re: Convert CSV to XPT

andreas_lds — Thu, 29 Nov 2018 08:18:13 GMT

Your first libname statement is wrong ... if you want to access datasets in WORK you just write work.DatasetName.

You should have a look at https://communities.sas.com/t5/SAS-Programming/Issue-converting-Length-greater-the-230-in-XPT-c/m-p/515491/highlight/true#M139087, especially the comment posted by @RW9

Re: Convert CSV to XPT

Kurt_Bremser — Thu, 29 Nov 2018 08:35:53 GMT

libname source 'Work.ImportedFile';

the second argument of a libname statement (if no engine designator is used) has to be a physical path name; using a two-level (library.dataset) dataset name can't work.

To export a single dataset, do

libname xportout xport 'C:\ADA\Filename.xpt';
data xport.nameoffile;
set work.nameoffile;
run;

But, given the limits of XPT, I'd rather do

proc cport
  data=work.nameoffile
  file='C:\ADA\Filename.cpt'
;
run;

Re: Convert CSV to XPT

RW9 — Thu, 29 Nov 2018 09:39:46 GMT

Really, the software JMP (or SAS Viewer - I think these are two different applications) only accepts XPT files? If so delete it from your system. XPT is a dreadful old file format. I really do think you should be able to import CSV, or plain dataset into most software nowadays.

Re: Convert CSV to XPT

Kurt_Bremser — Thu, 29 Nov 2018 10:21:45 GMT

And if you simply want to import data into a non-SAS application, use csv or any other textual format (fixed columns, tab-separated, etc) for that. No need to make that extra detour through the Universal Viewer (which, in fact, does not support the CPORT format. Dreadful).

Re: Convert CSV to XPT

cjoshi — Thu, 29 Nov 2018 15:40:40 GMT

I have no choice but to convert to .xpt as that is what is required. For some reason they have said not to use cport.

Re: Convert CSV to XPT

cjoshi — Thu, 29 Nov 2018 15:41:29 GMT

Sadly I need to convert to .xpt. I have heard from many people that they prefer not to work with it, but there are instances where it's still requested.