Export sas7bdat file to csv

[ShwetaMishra]

Hi,

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. 

[JBailey · Accepted solution]

Hi @ShwetaMishra

PROC EXPORT can do this.

Base SAS® 9.4 Procedures Guide, Seventh Edition - EXPORT Procedure

Best wishes,
Jeff

[art297]

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

[ShwetaMishra]

I wish to do this through Java or scala program. 

[JBailey]

Hi,

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.

Best wishes,

Jeff