Dear community, I have the following code but it gives me an error that I do not know how to fix. Please advise. ***************** CODE********************* %macro impt(filename,i); proc import DATAFILE="&filename" OUT=XL&i DBMS=XLSX REPLACE; run; %mend impt; %let path = E:\Lev1\Data\1_INPUTDOCS\IMPDOC\; data _null_; command = "dir &path.*.xlsx /b";; infile dummy pipe filevar=command end=eof truncover; do i = 1 by 1 while(not eof); input path $128.; path=catt("&path.",path); put 'NOTE: ' path=; call execute(cats('%nrstr(%impt(',path,',',i,'));')); end; stop; run; data all; set XL:; run; *********** ERROR LOG ****************** ERROR: Insufficient authorization to access PIPE. command=dir E:\Lev1\Data\1_INPUTDOCS\IMPDOC\*.xlsx /b eof=0 i=. path= _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 41 42 data all; 43 set XL:; ERROR: The data set list (WORK.XL:) does not contain any members. 44 run;
... View more