/** 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
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.
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.