The SAS Output Delivery System and reporting techniques

Special characters in database are replaced by '?' in sas dataset.

Reply
Contributor
Posts: 69

Special characters in database are replaced by '?' in sas dataset.

In a database called eTrack for the clinical study the last name has been entered as:
last name = Castaño
last name = Peña

However, when i extract the dataset the name outputs as 'Casta?o' and 'Pe?a' in the sas dataset.
N/A
Posts: 0

Re: Special characters in database are replaced by '?' in sas dataset.

Posted in reply to Siddhartha
The use of a tilde as a diacritical is most often seen in Spanish, and these names seem to have a Spanish origin. Unfortunately, when it was first developed, the IBM standard character set did not include many of the accents used in other languages, and it is only the extended character sets where you will find these available for users.

Word generally renders the extended character sets correctly, but a lot of simpler packages do not. I have no idea where you "extract the dataset" to, but I suspect it is a limitation of that package, and not of SAS.

If the issue is with SAS then look at the National Language setting of your SAS session.

Kind regards

David
N/A
Posts: 1

Re: Special characters in database are replaced by '?' in sas dataset.

Posted in reply to Siddhartha
Hi All
I have problem when i want to insert word 2003 symbols to SAS, then it shows ? in the SAS. Any idea?
Super Contributor
Super Contributor
Posts: 3,174

Re: Special characters in database are replaced by '?' in sas dataset.

SAS support website reference for National Language Support or NLS:

http://support.sas.com/documentation/onlinedoc/nls/


Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 3 replies
  • 143 views
  • 0 likes
  • 4 in conversation