DATA Step, Macro, Functions and more

Importing special characters from Excel

Reply
N/A
Posts: 0

Importing special characters from Excel

I have an Excel spreadsheet that contains a character variable with some entries containing special characters (arrows). When I attempt to import the dataset into SAS either with proc import or as a .csv file through a datastep and infile statement, these special characters are represented as dashes.

Is there a way to get SAS to import these special characters?
N/A
Posts: 0

Re: Importing special characters from Excel

I think it would be important to know your version of SAS, as in the version 9.2 there are introduced new informats for non-standard data.
Trusted Advisor
Posts: 2,113

Re: Importing special characters from Excel

I suspect not. Those 'special characters' are typically a character in a different font. There are just 255 possible characters in the ASCII collating sequence, so most of those TrueType fonts that you see in Excel will collapse into the limited set in ASCII.
Ask a Question
Discussion stats
  • 2 replies
  • 599 views
  • 0 likes
  • 2 in conversation