ERROR: Server Name is invalid or missing when Proc import excel file in SAS university edition

[petergomillion]

Hi, 

I'm having trouble importing an excel file with the IMPORT procedure 

proc import datafile= "/folders/myfolders/m2_pizza.xlsx"
run;

I'm getting this error message: 

ERROR: Server Name is invalid or missing

[SASKiwi]

Try adding the DBMS option:

proc import datafile= "/folders/myfolders/m2_pizza.xlsx" dbms = xlsx;
run;

[petergomillion · Accepted solution]

Thanks! I wound up adding the DBMS option as well as the other option where Output where it created a dataset. Seemed to work. 

[Mive]

This got me past the error. Thx

[Kurt_Bremser]

Your proc import statement is also missing the necessary semicolon.