Reading in ASCII help

[NJGIRL]

Hello All!

I am trying to read in an excel spreadsheet -- I am getting these 'funny' characters , which I believe is caused by ENTER key (?) . I have tried using the option ENCODING=Yes and SAS server UTF8 , which usually works, however this time I am stumped!

I have attached an example of my results. Thank you.

[ChrisNZ]

Many people will not look at MS Office files.

[Tom]

Those don't look like either CR or LF, which is what a line break would look like.

Ask SAS to show you want characters they are by using the $HEX format.

data _null_;
  set have (obs=5);
  put item_desc $hex.;
run;