Part I filename in '/home/u50158717/FILE(HOME)'; filename out zip '/home/u50158717/FILE.HOME.zip'; data _null_; length fname mname $256 ; infile in('*') filename=fname ; input; mname = scan(fname,-1,'/\'); file out MEMVAR=mname; put _infile_; run; quit;   filename in 'path to files'; precisely what is this? I have filename in '/home/u50158717/FILE(HOME)'; It is not working. Part II is working just fine.   Part II filename in '/home/u50158717/macros'; filename out zip '/home/u50158717/macros.zip'; data _null_; length fname mname $256 ; infile in('*') filename=fname ; input; mname = scan(fname,-1,'/\'); file out MEMVAR=mname; put _infile_; run; quit;   ... View more

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 options mrecall; %macro importXLSX(data,data2,getnames); options validVarName=any; proc import datafile="/home/u63984272/macros/&data..xlsx" dbms=xlsx out=&data2 replace; getnames=&getnames; sheet="Sheet2"; *datarow=n; *range="range name"; *mixed=yes; run; quit; %mend importXLSX; 83 options dlcreatedir; libname target "/home/u63984272/macros"; NOTE: Libref TARGET was successfully assigned as follows: Engine:        V9 Physical Name: /home/u63984272/macros %importXLSX(data=sheet2.XLSX,data2=target.sheet2,getnames=yes);   ERROR: Physical file does not exist, /home/u63984272/macros//sheet2.XLSX. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):   folder target is empty and sheet2.xlsx is only in /home/u63984272/macros//sheet2.XLSX. ... View more

  libname target "/home/u63984272/macros"; Both the data and this macro are in "/home/u63984272/macros"; where should the libname go?   70 %macro importXLSX(data,data2,getnames); 71 options validVarName=any; 72 proc import datafile="/home/u63984272/macros/&data..xlsx" 73 dbms=xlsx 74 out=&data2 75 replace; 76 getnames=&getnames; 77 sheet="Sheet2"; 78 *datarow=n; 79 *range="range name"; 80 *mixed=yes; 81 run; quit; 82 %mend importXLSX; 83 84 options dlcreatedir; 85 libname target "/home/u63984272/macros"; NOTE: Libref TARGET was successfully assigned as follows: Engine: V9 Physical Name: /home/u63984272/macros 86 %importXLSX(data=sheet2.XLSX,data2=sheet2.XLSX,getnames=yes); ERROR: Library name is not assigned. NOTE: The SAS System stopped processing this step because of errors. ... View more