As a newer SAS user, I have learned the "proc import" method of importing .xlsx files using the full filename. Now that I am working with more files, I wanted to see if it was possible to use a defined libname or path when importing instead of the full filename. That way, if I have to move files to a new folder, I only have to change the path in one location instead of many. Basically, I currently use this: Proc import out= want datafile="C:\Users\Example1\Example2\want.xlsx" dbms=xlsx replace; run; And I want to know if there's any way to do something like: libname Main "C:\Users\Example1\Example2"; Proc import out= want datafile=Main.want.xlsx dbms=xlsx replace; run; This is my first post on these forums, so let me know if I need more information. Thank you for any help!
... View more