unable to import excel file which having arabic text

[vallsas]

hi all,

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

[Sam_SAS]

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

[vallsas]

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

[SASKiwi]

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.

[vallsas]

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

[SASKiwi · Accepted solution]

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.

[vallsas]

[image: image.png]

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

[SASKiwi]

@vallsas  - The screenshot isn't showing.

[vallsas]

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]

[SASKiwi]

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

[vallsas]

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.