DATA Step, Macro, Functions and more

Export sas dataset into CSV

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Export sas dataset into CSV

Hi,

 

I am trying to export a dataset with the extension .sas7bdat into a csv file but I keep getting this error:

     ERROR: FILE= or TABLE= is required and must be specified.

 

 

Does anyone have a suggestion to overcome this error message or have a better way to export this file into a CSV file?

 

The main goal here is to be able to use my dataset with a .sas7bdat extension with the MatLab Software.

 

 

Thank you,

 

 

 

PROC EXPORT data=memory.cds_2001_2005;
    OUTFILE='G:\AAG\Market\CDS.csv';
    DBMS=csv replace;
run;

 


Accepted Solutions
Solution
‎03-31-2016 05:35 PM
Respected Advisor
Posts: 3,777

Re: Export sas dataset into CSV

you have 2 too many semicolons

View solution in original post


All Replies
Solution
‎03-31-2016 05:35 PM
Respected Advisor
Posts: 3,777

Re: Export sas dataset into CSV

you have 2 too many semicolons

Super User
Posts: 5,085

Re: Export sas dataset into CSV

In PROC EXPORT, OUTFILE and DBMS are options on the PROC statement.  They aren't separate statements.  Try removing the first two semicolons.

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 233 views
  • 2 likes
  • 3 in conversation