Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Adding a SAS data source

UserBird
Dataiker
Adding a SAS data source
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!
0 Kudos
3 Replies
UserBird
Dataiker
Author
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
Level 3

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
Dataiker Alumni

Thanks for sharing this with us @MarkPundurs

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku