Problem opening a file from a SAS server

[Gieorgie]

I have glb path defined. and I would like to import one thing from there, but I get an error

ERROR 22-322: Syntax error, one of the following was expected:;, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE,
_DEBUG_.

%let glb_path="/sas/dev/data/groups/bpr/rep/input/finance";
proc import out=MSSF9_17
			datafile="&glb_path./odpisy_mssf9_20171231_BO_v4_20180212.xlsx"
            dbms=excels replace;
     sheet="BO"; 
run;

[andreas_lds]

Afaik "excels" is not a valid value for dbms, try "excelcs" instead. If that doesn't work, please post full log.

[Kurt_Bremser]

Use the better (built-in, platform-independent) XLSX engine:

%let glb_path="/sas/dev/data/groups/bpr/rep/input/finance";

proc import
  out=MSSF9_17
  datafile="&glb_path./odpisy_mssf9_20171231_BO_v4_20180212.xlsx"
  dbms=xlsx
  replace
;
sheet="BO"; 
run;