Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Adding a SAS data source
Added on February 5, 2016 3:28AM
Likes: 0
Replies: 3
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!
Thanks for all the help!
Answers
-
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.
-
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, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭Thanks for sharing this with us @MarkPundurs
!
