topic Re: Exporting a SAS Dataset to .CSV File in SAS 9.4 in New SAS User

Exporting a SAS Dataset to .CSV File in SAS 9.4

yli33 — Fri, 23 Nov 2018 19:04:45 GMT

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 — Fri, 23 Nov 2018 19:11:50 GMT

Can you post your log please.

r_behata — Fri, 23 Nov 2018 19:15:31 GMT

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;

EPasol — Fri, 23 Nov 2018 19:17:26 GMT

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

yli33 — Fri, 23 Nov 2018 19:19:04 GMT

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

yli33 — Fri, 23 Nov 2018 19:19:26 GMT

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

Tom — Sat, 24 Nov 2018 08:12:38 GMT

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;