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?
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.
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.
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.