BookmarkSubscribeRSS Feed
Obsidian | Level 7

Hi Folks,


I am currently investigating an issue that is happening for users when they are trying to do the PROC import with datafile parameter containing an excel file which has Japanese characters in its name. 

We are using SAS 9.4M6 and have UTF8 as the SASApp workspace server.


ERROR: Error opening XLSX file -> /sas/....//<Japanese characters>.xlsx . It
is either not an Excel spreadsheet or it is damaged. Error code=8000100F
Requested Input File Is Invalid


Can someone please explain and suggest how to get rid of this?


Hi @sandeeppajni2 


A couple of questions:


  1. Does the Excel file open in Excel?
  2. Does the Excel file import if you change the name of the file and remove the Japanese characters?

I want to know if it is the filename that is the issue, or the file itself.

If it is the filename that's the issue, I suggest opening a track with SAS Technical Support

Obsidian | Level 7


Yes, the file opens fine within Excel. It imports fine when we change the name to non-Japanese keywords. So, issue seems to be happening when we try to import the excel file with Japanese keywords in its name. We also tried to use fewer or other Japanese characters in the name, but it did not help.


I will raise a case with SAS Technical Support now.



Super User Tom
Super User

Please let us know the answer.  This question of utf-8 characters in filenames on Unix not working has come up before, but I could not generate a search term that would find the previous discussion to see if there was a recommended resolution.


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1 like
  • 3 in conversation