BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Walternate
Obsidian | Level 7

Hi,

 

I have some files which I read in from Excel. 

 

There are some long strings which have carriage returns in the middle. I need to remove the CR but leave the rest of the value intact. Is this possible?

 

Thanks!

1 ACCEPTED SOLUTION
7 REPLIES 7
Walternate
Obsidian | Level 7

I tried the following:

 

directory3 = compress(directory2, '0d'x);

 

I did not get an error message but the carriage returns are still there. Did I miss some punctuation or a modifier or something?

ErikLund_Jensen
Rhodochrosite | Level 12

hi @Walternate 

 

You could try removing '0A'x (the line feed char) also. Might solve your problem.

Reeza
Super User

Use a HEX format on your character string to see the character in the string.

 

proc print data=have;
var stringVar;
format stringVar $hex50.; *make sure there's an appropriate length;
run;
ballardw
Super User

I strongly suspect that you want to replace the character with a space. Removing the line feed means the resulting text will be poor for reading.

 

Example:

This is an Excel value
split to two or more
lines.

When you remove the line feeds you will get

This is an Excel valuesplit to two or morelines.

The TRANSLATE function will replace a character with another.

Walternate
Obsidian | Level 7

Is there any way to change my output program which built the Excel files so that it is only outputting text values and no weird characters? 

 

To output I am just using ods excel and proc printing a data file. 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 697 views
  • 4 likes
  • 6 in conversation