topic Re: How to Convert a SAS data file to SPSS file in SAS Programming

How to Convert a SAS data file to SPSS file

wavogo — Fri, 21 Apr 2023 20:06:04 GMT

Dear SAS SUPPORT,

I have a hard time exporting a SAS file into SPSS. When I use the code below I get an error.

PROC EXPORT DATA=Under5_1;

OUTFILE='C:\Users\wavogo\KEIR72SD\spssdata.sav';

DBMS=SPSS REPLACE;

FILE="C:\Users\wavogo\KEIR72SD\Under5_1";

RUN;

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

Would know what might help? I don’t have STAT/TRANSFER and I can’t open the SAS file directly in SPSS.

Thank you so much for your help.

Winfred

I get the error:

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

Would know what might help? I don’t have STAT/TRANSFER and I can’t open the SAS file directly in SPSS.

Kurt_Bremser — Fri, 21 Apr 2023 20:48:19 GMT

Remove the semicolons after the options. They all must be part of the PROC EXPORT statement.

proc export
  data=Under5_1
  file='C:\Users\wavogo\KEIR72SD\spssdata.sav'
  dbms=spss
  replace
;
run;

wavogo — Fri, 21 Apr 2023 23:30:52 GMT

Thank you so much. It worked!