04-14-2017 09:38 AM
I have to export SAS7bdat file to csv. I tried using spark-sas7bdat package and R functions for SAS but both failed with large file.
Please suggest the best way to export large sas file to csv.
04-14-2017 09:47 AM
Just use a data step. See: https://communities.sas.com/t5/SAS-Procedures/Proc-Export-for-large-files/td-p/188894
Art, CEO, AnalystFinder.com
04-14-2017 10:04 AM
The only way to read a SAS data set is through SAS. Your Scala or Java program would have to execute SAS in order to do this. There is an SAS ODBC driver, but that will use SAS to read the SAS data set.