Exporting a SAS Dataset to .CSV File in SAS 9.4

[yli33]

Hi, 

I have attempted to export a SAS dataset to .csv using the following piece of code but to no avail:

PROC EXPORT DATA=XXX;
            OUTFILE="File Pathname"
            DBMS=CSV REPLACE;
     PUTNAMES=YES;
RUN;

In fact, I received an error message that states the following: 

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

Therefore, I would greatly appreciate it if someone could offer a solution to this issue. Thanks in advance!

[Reeza]

Can you post your log please.

[r_behata]

Remove the highlighted Semi-colon and try

PROC EXPORT DATA=XXX  ;
            OUTFILE="File Pathname"
            DBMS=CSV REPLACE;
     PUTNAMES=YES;
RUN;

Should be :

PROC EXPORT DATA=XXX
            OUTFILE="File Pathname"
            DBMS=CSV REPLACE;
     PUTNAMES=YES;
RUN;

[yli33]

Thank you so much for detecting that error! It works now!

[EPasol]

You have to remove the semi-colon after DATA=XXX;

[yli33]

Thank you so much for detecting that error! It works now!

[Tom]

Here is a coding style tip to help avoid that type of error.

When you have a statement that spans multiple lines put the semi-colon that ends the statement on its own line:

PROC EXPORT DATA=XXX
            OUTFILE="File Pathname"
            DBMS=CSV REPLACE
;
     PUTNAMES=YES;
RUN;

The same way that you would place the END for a DO/END block:

if a=b then do;
  statement1;
  statement2;
end;