Carriage return from excel in to SAS

Reply
Occasional Contributor
Posts: 6

Carriage return from excel in to SAS

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

Contributor
Posts: 74

Re: Carriage return from excel in to SAS

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.

Grand Advisor
Posts: 9,571

Re: Carriage return from excel in to SAS

You could check

'0D0A'x

'0A'x

or just

put a $hex.;

to see what exactly it is .

Ask a Question
Discussion stats
  • 2 replies
  • 150 views
  • 0 likes
  • 3 in conversation