@NN wrote:
Hi everyone,
I have a process where we use proc import (dbms=xlsx) to import an excel file.
We then use libanme ODBC to connect to an SQL server and create the imported table in SQLserver.
Now one of the columns in the excel has values with special characters like the circle bullet symbol.
When we import the excel into sas we can see the bullet in the sas dataset.
But when we transfer the data to the SQL server the bullet changes to a sort of right arrow -> .
We are on sas Unix environment with Latin1 encoding. I don't have the option of starting a session with UTF8 encoding.
Is there any other solution that I can try to fix this issue?
What does that represent in the Excel spreadsheet, what should it be?
are you sure that it is SAS and not SQL that is changing your char(7) or char(149) into this ->
Just an idea. Have you tried using the INENCODING= and OUTENCODING= options?
I guess your SAS and SQL Server needs to have same encoding.
Try this: SELECT SERVERPROPERTY('Collation')
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.