How to unwrap a string in a column

[Vimal08]

Hi Team, I have a column where output is a string that looks like a path (/home/sas/demo/data). But the value is getting wrapped and the output is coming like this: /home/sas/ demo/data Please help me, how I can unwrap this string in the output? and get the desire output (/home/sas/demo/data). Your help will be highly appreciated.

[Tom]

---

@Vimal08 wrote:
Hi Team, I have a column where output is a string that looks like a path (/home/sas/demo/data). But the value is getting wrapped and the output is coming like this: /home/sas/ demo/data Please help me, how I can unwrap this string in the output? and get the desire output (/home/sas/demo/data). Your help will be highly appreciated.

---

What output?  What procedure produced the output?  What type of destination did you use?

Can you create a simplified example that exhibits the issue?

Either include that data in your example as a SAS data step.  Or use one of the existing SASHELP datasets to demonstrate the issue.

[Reeza · Accepted solution]

Try the COMPRESS() function with the S modifier. However, if you have spaces in the path those will also disappear. 

var = compress(var, , 's');

If you need to remove only carriage returns you can try the following where '0x0D'x is the hex code for a carriage return/line wrap.

var_clean = compress(var, '0x0D'x)

---

@Vimal08 wrote:
Hi Team, I have a column where output is a string that looks like a path (/home/sas/demo/data). But the value is getting wrapped and the output is coming like this: /home/sas/ demo/data Please help me, how I can unwrap this string in the output? and get the desire output (/home/sas/demo/data). Your help will be highly appreciated.

---

[Vimal08]

Thank you. It worked.

[Ksharp]

Reeza,

var_clean = compress(var, '0x0D'x)
could wrote as
var_clean = compress(var, '0D'x)
?

[Reeza]

Yes, appears that also works 🙂

[Tom]

23   data _null_;
24     c1 = '0D'x;
25     c2 = '0x0D'x ;
ERROR: Invalid hexadecimal constant string '0x0D'x.
26     put (c1 c2) (=$hex.);
27   run;