DATA Step, Macro, Functions and more

Read an Excel file using proc import when the file is open

Reply
New Contributor
Posts: 2

Read an Excel file using proc import when the file is open

Is it possible to read an Excel file using proc import when the file is open? If yes, how?

Super User
Posts: 3,102

Re: Read an Excel file using proc import when the file is open

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.  

New Contributor
Posts: 2

Re: Read an Excel file using proc import when the file is open

[ Edited ]

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. 

Ask a Question
Discussion stats
  • 2 replies
  • 173 views
  • 0 likes
  • 2 in conversation