topic Re: unable to import excel file which having arabic text in SAS Visual Analytics

unable to import excel file which having arabic text

vallsas — Wed, 02 Jun 2021 15:08:49 GMT

hi all,

unable to import the excel file .xls (excel 97-2003) which is having arabic text .

Re: unable to import excel file which having arabic text

Sam_SAS — Wed, 02 Jun 2021 15:40:00 GMT

I asked a colleague about this and he suggested that you contact SAS Technical Support. https://support.sas.com/en/technical-support.html

He says you should not normally see this error.

You might also want to try a different file with Arabic characters to be sure the problem is not limited to one specific file.

Thanks,

Sam

Re: unable to import excel file which having arabic text

vallsas — Wed, 02 Jun 2021 15:47:18 GMT

Yes, I did multiple files but no luck. same file with out arabic text importing with out any error .
Thanks

Re: unable to import excel file which having arabic text

SASKiwi — Thu, 03 Jun 2021 02:47:20 GMT

Do you by any chance know or can find out the encoding being used in the CSV file you are importing? I notice you have an encoding of UTF-8 specified in the VA import screen. This obviously is not compatible with your CSV. Aligning the encoding to match the file will likely fix your problem.

Re: unable to import excel file which having arabic text

vallsas — Thu, 03 Jun 2021 05:00:56 GMT

hi
i am importing .xls file not csv what is show is in our screen, it was a
sas option showing nothing i did with csv file extension.

also utf-8 also it was default I did not make any thing.

i request if you have access on va just type the arabic text in excel
with.xls file then test it. so
that you will be experienced the problem.

thanks for your help

Re: unable to import excel file which having arabic text

SASKiwi — Thu, 03 Jun 2021 21:03:20 GMT

According to this link ARABIC is the supported encoding for this language. Try changing UTF-8 to ARABIC when importing.

The only problem is that SAS VA would have to have been installed with the NLS extensions for Arabic for this to work.

Re: unable to import excel file which having arabic text

vallsas — Fri, 04 Jun 2021 08:06:56 GMT

[image: image.png]

Please see the erro when I change the UTF-8 to ARABIC

Re: unable to import excel file which having arabic text

SASKiwi — Fri, 04 Jun 2021 08:35:17 GMT

@vallsas - The screenshot isn't showing.

Re: unable to import excel file which having arabic text

vallsas — Fri, 04 Jun 2021 09:03:56 GMT

Hi

Sorry I did not save the screenshot.
When I try to import the data now those options(Source encoding:,Input file
delimiter:and Scanned rows:Locale:) are disappear in our sas free trail VA .
at present I have successfully imported the excel file .xls

[image: image.png]

Re: unable to import excel file which having arabic text

SASKiwi — Fri, 04 Jun 2021 23:17:27 GMT

@vallsas - Great, please update your post as answered then.

Re: unable to import excel file which having arabic text

vallsas — Sat, 05 Jun 2021 07:03:17 GMT

Yes, Problem has been resolved, after adding encoding to ARABIC while importing the ,xls excel97-2003 workbook format which contains some columns Arabic text.

Thanks for the support.