SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Export sas7bdat file to csv

Reply
New Contributor
Posts: 2

Export sas7bdat file to csv

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. 

 

SAS Employee
Posts: 203

Re: Export sas7bdat file to csv

Hi @ShwetaMishra

 

PROC EXPORT can do this.

 

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

 

Best wishes,
Jeff

PROC Star
Posts: 7,360

Re: Export sas7bdat file to csv

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

 

New Contributor
Posts: 2

Re: Export sas7bdat file to csv

I wish to do this through Java or scala program. 

SAS Employee
Posts: 203

Re: Export sas7bdat file to csv

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

Ask a Question
Discussion stats
  • 4 replies
  • 196 views
  • 0 likes
  • 3 in conversation