topic Reading in ASCII help in SAS Programming

Reading in ASCII help

NJGIRL — Thu, 01 Aug 2019 14:24:48 GMT

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.

Re: Reading in ASCII help

ChrisNZ — Fri, 02 Aug 2019 02:39:26 GMT

Many people will not look at MS Office files.

Re: Reading in ASCII help

Tom — Fri, 02 Aug 2019 03:07:46 GMT

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;