BookmarkSubscribeRSS Feed
sandeeppajni2
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?

3 REPLIES 3
AMSAS
SAS Super FREQ

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


sandeeppajni2
Obsidian | Level 7

Hi @AMSAS,

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.

 

Thanks!

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 581 views
  • 1 like
  • 3 in conversation