Hi I usually run a bit of code in Base SAS and it always runs fine. We have moved to EG and it now doesn't allow me to run it due to "Insufficient Authorization to access PIPE". The code is below, is anyone able to provide a solution to reading in lots of differently named spreadsheets and retain the information required from each spreadsheet (where DIRECTORY_NAME is my library path)? Thanks %LET dir = "DIRECTORY_NAME"; %let DIRLIST = %UNQUOTE(%STR(%'for /r &dir. %I in (*.XLS*) do @echo %~ztfI%')); filename DIRLIST pipe &DIRLIST.; data out1_orig; infile dirlist length=reclen truncover; input line $varying256. reclen; FORMAT DATE DDMMYY10. TIME $5. FILESIZE comma15. FILENAME $200. ; reclen=reclen; Date = input(substr(line,1,10), ?? ddmmyy10.); Time = scan(line,2,' '); Filesize = scan(line,3,' '); call scan(line,4,pos,len,' ');pos = pos/*-1*/; FileName = substr(line,pos,reclen-pos); MonthGrp = PUT(intnx('month',Date,0,'e'),YYMMN7.); GrpNum = intnx('month',Date,0,'e'); posFS = prxmatch("|\\[^\\]*$|", FileName); FileFolderOnly = substr(line,pos,posFS); FileNameOnly = substr(line,pos+posFS,reclen-pos); run;
... View more