I can connect to a specific .txt, .csv, or .xlsx in a network drive. What I cannot get SAS EG to do is just to connect to the drive and let me see what is in there. I have all the files I need in multiple subfolders that are zipped and what I want is to have my SAS EG connect to the drive so I can see all the subfolders from the tree and pick what I want to bring in as far as zipped and then pull out the .txt. I have overall 621 .txt files that will end up imported and we have tried every option to try and get this to work and this is like the last straw figuring out how to import all with SAS. Right now I have this as my code and it says does not exist LIBNAME MYCODE2 '\\networkdrive\folder\subfolder\'; If I point to an xlsx it gets right to it no errors LIBNAME MYCODE2 PCFILES SERVER="&IP" PATH='\\NETWORKDRIVE\FOLDER\SUBFOLDER\FILE.XLSX' DBCOMMIT=0 READBUFF=500 INSERTBUFF=500;RUN;
... View more