topic Re: Export sas7bdat file to csv in SAS Data Management

Export sas7bdat file to csv

ShwetaMishra — Fri, 14 Apr 2017 13:38:45 GMT

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.

Re: Export sas7bdat file to csv

JBailey — Fri, 14 Apr 2017 13:46:20 GMT

Hi @ShwetaMishra

PROC EXPORT can do this.

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

Best wishes,
Jeff

Re: Export sas7bdat file to csv

art297 — Fri, 14 Apr 2017 13:47:29 GMT

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

Re: Export sas7bdat file to csv

ShwetaMishra — Fri, 14 Apr 2017 13:58:27 GMT

I wish to do this through Java or scala program.

Re: Export sas7bdat file to csv

JBailey — Fri, 14 Apr 2017 14:04:08 GMT

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