topic Re: How to import data from excel file without closing the excel file? in New SAS User

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

IgorR — Thu, 10 Aug 2023 06:53:54 GMT

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

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

Kurt_Bremser — Thu, 10 Aug 2023 07:17:31 GMT

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.

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

andreas_lds — Thu, 10 Aug 2023 08:57:36 GMT

@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.

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

IgorR — Thu, 10 Aug 2023 11:13:29 GMT

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.