Post reply

Exporting Data in .SAS format

  • March 11, 2016 at 4:56 am

    #305623

    Not sure this is the right section to put the question - however

    I have been asked by a third party to provide some data from our SQL databases and they want it in a SAS XD dataset.

    Now in my mind, I just drop the data into a .csv format, they can import that and everyone is happy.

    They are insisting that we create the SAS format - is that possible from SQL ?

    I have seen WPS mentioned elsewhere, but whilst that allows you to have a similar programming language it doesn`t appear to create the output in anything different from csv.

    Anyone have any thoughts ?

    Thanks

  • March 11, 2016 at 5:41 am

    #1864536

    I never had to do this, but i found this interesting!

    i found a good article on SQLTips called "Transferring data from SAS to SQL Server and back":

    https://www.mssqltips.com/sqlservertip/2659/transferring-data-from-sas-to-sql-server-and-back/

    so if you don't have SAS yourself, it looks to me that you still just export a bunch of CSV's and it's up to them to import it into SAS.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 14, 2016 at 3:32 am

    #1864855

    As an update.

    I have found this program - https://www.stattransfer.com/index.html

    Only a couple of hundred dollars and looks to be exactly what I need to transfer data into the appropriate SAS formats (either the xpt SAS transfer format, or the full SAS db format).

    Definitely worth a look if you have a similar issue.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply