SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS Formating - how to create from SQL database

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

SAS Formating - how to create from SQL database

I currently have no SAS installation. I manage a series of SQL databases.


A client has requested that we provide a SAS XD format file once a month for them. They will only accept the data in SAS XD format.

 

There is no way that SQL can create a file in that format and searching around there seems little option in doing this.


I guess the question is what is the most cost effective way for me to install SAS (in whatever form necessary) that will allow me to import a SQL file and generate a SAS XD file.

 

I have no other need to use the data within SAS.

 

Odd question I know, but any thoughts would be great.

 

Thanks


Accepted Solutions
Solution
‎03-14-2016 05:28 AM
Super User
Posts: 11,343

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

A quick search shows that you might investigate a program called StatTransfer at https://www.stattransfer.com/index.html

 

On a quick view it looks like it will create SAS transport files from a variety of file formats. If you data base isn't directly suported it looks like it will accept ASCII delimited (CSV) files for input.

 

View solution in original post


All Replies
Super User
Super User
Posts: 7,970

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

By SAS XD format, do you mean a SAS transport file = .xpt?  Never heard of an CD format.  If it is a SAS version 5 transport file, then the file format is open source.  I know some authorities still require this file format.  

http://www.lexjansen.com/pharmasug/2009/ad/AD08.pdf

 

As for getting SAS, well you could use the UE version to do this (its limited and can't remember what the limitations are), otherwise you would need a SAS license.  Actually creating the files from within SAS is very simple, but there is that initial cost.

 

I would again question the need for XPT file with them however.  In this day and age XPT should be gone, its very old.  Most proprietary formats should be long gone.  CSV files are better.  XML based data are starting to come through heavily as is other open source plain text, cross system file formats.  And these two would be the starting point for my discussions.

Super User
Posts: 19,815

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

If you decide you absolutely require SAS, SAS University Edition will not meet the licensing requirement.


You can install a local version of SAS on a  desktop, set up a connection to your SQL server using ODBC and then you can export the data or do whatever else you want in SAS.

 

If you don't have a license, it may be worth contracting out that conversion...SAS licenses are spendy...

New Contributor
Posts: 3

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

Thanks for the input - very useful.


I will go back to my contacts and discuss the possibilities of different formats. It is Pharma though so can see them digging their heels in.

Solution
‎03-14-2016 05:28 AM
Super User
Posts: 11,343

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

A quick search shows that you might investigate a program called StatTransfer at https://www.stattransfer.com/index.html

 

On a quick view it looks like it will create SAS transport files from a variety of file formats. If you data base isn't directly suported it looks like it will accept ASCII delimited (CSV) files for input.

 

New Contributor
Posts: 3

Re: SAS Formating - how to create from SQL database

Thanks for the link.

 

I had googled looking for a converison program but for some reason came up blank.

 

This does exactly what I need and a very palatable cost Smiley Happy

Super User
Super User
Posts: 7,970

Re: SAS Formating - how to create from SQL database

Posted in reply to SimonSmithBSA

I am in Pharma, the only time I dig my heels in (and then I really bury them) is when someone tries to give me an Excel file.  Not sure where in the process you are dealing with it, but in the Pharma world there is CDISC, an organisation that deals with standards for data transfer, and there are several models availble all of which are plain text XML, and should be industry standards - CDASH for databases, and SDTM also, ADaM for Analysis.  

http://www.cdisc.org/ 

Generally speaking a lot of clinical data is now sent about via XML and the above models, although XPT does hang around.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 463 views
  • 6 likes
  • 4 in conversation