Hello everybody. I need to import a SQL Server table in SAS. I've done this import with an ODBC connector, but in SQL Server table, there are rows with special characters, like ç, á, é, í... When I've imported this table to SAS, all the values with special char have changed. For example the value ÍNDIO was changed for ¿NDIO. How do I solve this problem with special character? Are there any people with the same problem? Import code is like this. proc sql;
connect to odbc as mycon
(datasrc=ora7 user=testuser password=testpass);
create table SAS_TABLE as
select * from connection to mycon
(select * from sasdemo.employees);
disconnect from mycon;
quit; Thank you so much. Best regards,
... View more