Adding a SAS data source

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
Looking to add a SAS dataset. When pulling into the New Upload section my preview doesn't spit anything out. Do I need a connector to do this? Didn't see anything with SAS under available or plugins.



Thanks for all the help!

Answers

  • UserBird
    UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
    Options
    You should be able to upload sas7bdat files directly to Dataiku DSS the same as any other file. However compressed files are not yet supported. For now, you can use python recipe (using the sas7bdat python package) to convert the file to csv before uploading it.
  • MarkPundurs
    MarkPundurs Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 26 ✭✭✭✭
    edited July 17
    Options

    To elaborate - Add the file to a managed folder, then create a Python code recipe and add lines like the following to the default recipe code:

    from sas7bdat import SAS7BDAT
    myfilename = '<myfile>.sas7bdat'
    with SAS7BDAT(myfilename, fh=datafiles.get_download_stream(myfilename)) as reader:
        <myoutputdatasetname>_df = reader.to_data_frame()

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Options

    Thanks for sharing this with us @MarkPundurs
    !

Setup Info
    Tags
      Help me…