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!
Use the COMPRESS function to remove "0d"x.
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?
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;
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.
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.
Use the FLOW="TABLES" option.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: