topic Re: How to unwrap a string in a column in SAS Programming

How to unwrap a string in a column

Vimal08 — Tue, 14 Jun 2022 15:12:29 GMT

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.

Re: How to unwrap a string in a column

Tom — Tue, 14 Jun 2022 15:23:18 GMT

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

Re: How to unwrap a string in a column

Reeza — Tue, 14 Jun 2022 15:43:53 GMT

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.

Re: How to unwrap a string in a column

Vimal08 — Tue, 14 Jun 2022 16:06:03 GMT

Thank you. It worked.

Re: How to unwrap a string in a column

Ksharp — Wed, 15 Jun 2022 12:34:40 GMT

Reeza,

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

Re: How to unwrap a string in a column

Reeza — Wed, 15 Jun 2022 15:15:09 GMT

Yes, appears that also works 🙂

Re: How to unwrap a string in a column

Tom — Wed, 15 Jun 2022 15:17:15 GMT

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;