topic Re: Add a space after a number in SAS Programming

Add a space after a number

luvscandy27 — Thu, 12 May 2022 11:49:34 GMT

Hi all,

I thought this question would be easy but I can't seem to find the answer.

Say I have data like below:

4red

56blue

118white

20022orange

And I would like to add a space after the numeric portion so my data looks likes this:

4 red

56 blue

118 white

20022 orange

How could I achieve this?

Re: Add a space after a number

PaigeMiller — Thu, 12 May 2022 12:06:10 GMT

If the numbers are always integers (are they?) then you can use the NOTDIGIT function

data want;
    set have;
    length newtext $ 24;
    where=notdigit(text);
    newtext=substr(text,1,where-1)||' '||substr(text,where);
run;

Re: Add a space after a number

luvscandy27 — Thu, 12 May 2022 12:19:24 GMT

Unfortunately, the whole string is character.

Re: Add a space after a number

PaigeMiller — Thu, 12 May 2022 12:29:44 GMT

@luvscandy27 wrote:

Unfortunately, the whole string is character.

That's not what I meant by "integer". In your examples

4red

56blue

118white

20022orange

all of the digits turn into integers. There are no non-integers such as

20.333orange

Re: Add a space after a number

maguiremq — Thu, 12 May 2022 13:15:45 GMT

data have;
input var :$25.;
datalines;
4red
56blue
118white
20022orange
;
run;

data want;
	set have;
	f = catx(" ", compress(var, , 'kd'), compress(var, , 'ka'));
run;

If length is an issue, make sure to use a LENGTH statement before the CATX statement.

Re: Add a space after a number

andreas_lds — Thu, 12 May 2022 13:22:25 GMT

Won't work with values like "111green222", but only @luvscandy27 knows whether values with multiple numbers exist.

Re: Add a space after a number

Ksharp — Fri, 13 May 2022 02:55:02 GMT

data have;
input var :$25.;
datalines;
4red
56blue
118white
20022orange
;
run;

data want;
	set have;
	want = prxchange('s/(\d+)/\1 /',1,var);
run;