How to import data from excel file without closing the excel file?

[IgorR]

Hi,

When I run Proc Import , SAS demands to close the excel file I'm importing from.

Is there a possibility to import when keeping the excel open?

Thanks

[Kurt_Bremser]

Excel opens files in read/write mode (and keeps them open), since it expects to update data. Always close files in Excel when you're done.

Or export to text (csv) and read that.

[andreas_lds]

---

@IgorR wrote:

Hi,

When I run Proc Import , SAS demands to close the excel file I'm importing from.

Is there a possibility to import when keeping the excel open?

Thanks

---

No.

[IgorR · Accepted solution]

Hi,

I found how to do it - just open the excel file in read-only mode.

So SAS can import data from the file and there no need to close the workbook.