Is it possible to read an Excel file using proc import when the file is open? If yes, how?
Unfortunately I don't think this is possible. Excel files are not designed for multi-user access - the first user opening it will lock the file. If you want to avoid errors of this type then set the permissions on these files to read-only.
OK 😞
I am asking because sometimes I need to edit an Excel and read it repeatedly. So I need to open and close it again and again. Thanks for you reply anyway.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.