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

Export sas7bdat file to csv

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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. 

 


Accepted Solutions
Solution
‎02-13-2018 11:01 AM
SAS Employee
Posts: 273

Re: Export sas7bdat file to csv

Posted in reply to ShwetaMishra

All Replies
Solution
‎02-13-2018 11:01 AM
SAS Employee
Posts: 273

Re: Export sas7bdat file to csv

Posted in reply to ShwetaMishra

Hi @ShwetaMishra

 

PROC EXPORT can do this.

 

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

 

Best wishes,
Jeff

PROC Star
Posts: 8,151

Re: Export sas7bdat file to csv

Posted in reply to ShwetaMishra

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: 273

Re: Export sas7bdat file to csv

Posted in reply to ShwetaMishra

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1721 views
  • 0 likes
  • 3 in conversation