topic Re: error in using importing file in SAS Studio

error in using importing file

rishabhmehra13 — Sun, 14 Aug 2016 12:27:12 GMT

/** Import an XLSX file. **/
libname g '/folders/myfolders/';
PROC IMPORT DATAFILE="/folders/myfolders/grocery_coupons.xls";
      OUT=g.permanent
      DBMS=XLSX
      REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=g.permanent; RUN;

log

Engine: V9

Physical Name: /folders/myfolders

58 PROC IMPORT DATAFILE="/folders/myfolders/grocery_coupons.xls";

ERROR: Output SAS data set must be provided.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

59 OUT=g.permanent

60 DBMS=XLSX

61 REPLACE;

62 RUN;

64 /** Print the results. **/

66 PROC PRINT DATA=g.permanent; RUN;

Re: error in using importing file

Reeza — Sun, 14 Aug 2016 13:43:59 GMT

The error is the same as in your last question.

https://communities.sas.com/t5/SAS-Analytics-U/Error-using-Proc-import/m-p/290978

There is no semicolon after the file path.

Re: error in using importing file

Cynthia_sas — Sun, 14 Aug 2016 14:11:00 GMT

Hi, in addition, please check the documentation for DBMS=XLSX -- you show that your file name is .XLS, not .XLSX, so you may be trying the wrong engine to read the file, once you get your syntax worked out.

cynthia

Re: error in using importing file

Tom — Sun, 14 Aug 2016 14:51:11 GMT

I always place the semi-colon on a multiple line statement on a new line and align it with the beginning of the statement. The lines in between are indented. The same way that I format DO/END blocks of code.

I find that is makes it much less likely that I will accidently insert an extra semi-colon into the middle of long statements.

libname g '/folders/myfolders/';
PROC IMPORT
  DATAFILE='/folders/myfolders/grocery_coupons.xlsx'
  OUT=g.permanent
  DBMS=XLSX
  REPLACE
;
RUN;