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

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

petergomillion — Sat, 14 Sep 2019 22:07:29 GMT

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 — Sun, 15 Sep 2019 06:08:49 GMT

Try adding the DBMS option:

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

Kurt_Bremser — Sun, 15 Sep 2019 05:07:17 GMT

Your proc import statement is also missing the necessary semicolon.

petergomillion — Sun, 15 Sep 2019 16:57:13 GMT

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 — Fri, 10 Sep 2021 07:53:59 GMT

This got me past the error. Thx