topic Carriage return from excel in to SAS in SAS Programming

Carriage return from excel in to SAS

bian123 — Wed, 22 Jul 2015 14:52:57 GMT

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

Re: Carriage return from excel in to SAS

evp000 — Fri, 24 Jul 2015 17:34:22 GMT

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.

Re: Carriage return from excel in to SAS

Ksharp — Sat, 25 Jul 2015 12:54:13 GMT

You could check

'0D0A'x

'0A'x

or just

put a $hex.;

to see what exactly it is .