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.
Many people will not look at MS Office files.
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;
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!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.