BookmarkSubscribeRSS Feed
Quartz | Level 8

We are currently importing Excel 2007 files to SAS using SAS proc import code. We found that SAS detects hidden characters and translates these to a question mark after import. May we know how can we make SAS not detect these hidden characters and import the data as is?

For example, this field has this value in Excel:

Its not going to happen.

When it was converted to SAS, it became:

It?s not going to happen.

How can we get rid of the question mark?

Super User

Export into .csv from Excel and use a hex-capable editor to inspect the data. This might give you a clue what's happening.

Most probably you have a difficulty with UTF vs single-byte representation.

A common single quote (which I would expect to be there) will always translate properly, so I guess someone used an extended character where it is not necessary.

Programmer's heaven is a place where English is the only language, and only 96 characters/symbols are needed.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation