topic Re: Problem opening a file from a SAS server in SAS Programming

Problem opening a file from a SAS server

Gieorgie — Wed, 06 Oct 2021 07:15:09 GMT

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;

Re: Problem opening a file from a SAS server

andreas_lds — Wed, 06 Oct 2021 07:24:02 GMT

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

Re: Problem opening a file from a SAS server

Kurt_Bremser — Wed, 06 Oct 2021 07:46:50 GMT

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;