Carriage return from excel in to SAS

[bian123]

Hi,

This is my first post so apologies if it is in the wrong place or incorrect in some way.

I assigned a libname to an excel workbook like this:

libname temp EXCEL "&workbook." dbmax_text=32767 getnames = no;

Some variables have large spaces in their values due to the fact that once cell in my excel workbook may have multiple lines split apart by some kind of newline character.

I removed these using the following code in a datastep:

variable= compress(variable,,"kw");

However I was wondering if anyone knew a specific string of characters I could search for as it would help me achieve my programming goal - I want to replace these characters with a space.

Thanks,

I hope someone can help

P.S. I use windows

[evp000]

You may find the NOTPRINT function helpful.  You can find the location of non-printing characters and replace them with blanks.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

There are also other threads on this forum for the same issue.

[Ksharp]

You could check

'0D0A'x

'0A'x

or just

put a $hex.;

to see what exactly it is .