topic Re: SAS job Failing to Read excel file in SAS Programming

SAS job Failing to Read excel file

Sreelekha — Thu, 04 Oct 2018 10:18:42 GMT

Hi All,

I have a .bat file which runs SAS scripts in the background.
The job has to pick a number of .csv files and .xls files from a specified path and run it to update the database.

The job is failing to pick the .xls file and failing with the error that. the .xls file was not found. But, that is not the case as the file is already present in that specified path.

If i run the SAS script individually, there are no errors.

There has been no code change in the previous months.
There was a server upgrade where the server was upgraded from Windows server 2008 to Windows server 2012. Is that related to this?

Could you guys please help me with a solution for this?

Regards,
Sreelekha

Re: SAS job Failing to Read excel file

Kurt_Bremser — Thu, 04 Oct 2018 10:36:19 GMT

Windows has such a convoluted security "concept" that it is quite easy to have different permissions (and/or network mounts) between a job run in interactive and a job run in batch mode, as those are different contexts even with the same user-id.

Note: when SAS tells you a file is not there, it's not there, period. Which can mean that the file is actually there, but there is not accessible to the SAS process at this very moment.

Re: SAS job Failing to Read excel file

RW9 — Thu, 04 Oct 2018 11:01:38 GMT

Are you sure the file is there, if the program tells you its not, I am going to believe that I am afraid. Note that:

"XYZ.xlsx" is not "X YZ.xslx"

and

"XYZ.xls" is not "XYZ.xlsx"

For example. AS we can't see anything of your process, can't help further.

Note, why on earth are you using xls file format, which is decades out of support. Move to XLSX, or better still bin Office in totum and go with nice plain open source files.

Re: SAS job Failing to Read excel file

Sreelekha — Thu, 04 Oct 2018 11:06:54 GMT

Thank you for your reply.

But the other CSV files from the same path are accessible. Since, yesterday I have been getting this error. Hence, this isnt momentary.

Re: SAS job Failing to Read excel file

Sreelekha — Thu, 04 Oct 2018 11:12:23 GMT

Yes,
But the individual script is running fine. Absolutely no errors.

Re: SAS job Failing to Read excel file

Kurt_Bremser — Thu, 04 Oct 2018 11:12:40 GMT

Show us the code and the log.

Re: SAS job Failing to Read excel file

Ksharp — Thu, 04 Oct 2018 11:25:18 GMT

Maybe that excel is open or locked.

Try to copy that excel to somewhere and import the copy file again.