/** 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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.