topic Re: Export XPT sas7bdat in linux using perl in SAS Programming

Export XPT sas7bdat in linux using perl

sujatha — Fri, 09 Oct 2015 10:03:26 GMT

Hi All,

I am new to perl. Normally, we export xls and pdf format from database. but one of client asks to export as xpt and sas xpt format. Please give some steps which software I install and installation steps. I cant view xpt and sas file normally. Its very very urgent to complete this task. Anybody give idea on this?

Thanks,

S.Sujatha

Re: Export XPT sas7bdat in linux using perl

LinusH — Fri, 09 Oct 2015 11:59:20 GMT

I guess that your user refers to the libname export engine:

http://support.sas.com/documentation/cdl/en/lrcon/68089/HTML/default/p052e5a7x9rhl8n1y1y7e82jfe0z.htm#n10qs7gemd0sdin1oocs8z952sfq

But I find export files created by PROC CPORT more useful, they keep more of data sets attributesn in the export file.

Re: Export XPT sas7bdat in linux using perl

LinusH — Fri, 09 Oct 2015 12:02:31 GMT

For software, you need to install Base SAS. If you wish to export data directly from the source database you might need a SAS/ACCESS module.

To avoid that, you could first export your data to an external file, import it to SAS, and then do the transport file. But as you hear, this is awkward.

So, what is the use case, why can't your user access the data directly from the database? Using ODBC or similar.

Re: Export XPT sas7bdat in linux using perl

Doc_Duke — Fri, 09 Oct 2015 12:26:24 GMT

This document contains the record layout for a SAS .xpt file

https://support.sas.com/techsup/technote/ts140.pdf

You do not need to have SAS installed to create a .xpt file.

Re: Export XPT sas7bdat in linux using perl

RW9 — Fri, 09 Oct 2015 12:57:57 GMT

Why do you have a need to do this? I find most in my industry at least are moving rapidly away from XPT (considering its a pretty old format now (version 6!). To my mind you would be better off putting your effort into XML output as that is the immediate future, and its open source.