How To Re arrange numbers in row wise ???

[Mohan_Reddy]

I Have dataset like below..





data stansys;
infile datalines;
input string $22.;
datalines;
two numbers 1 2
five numbers 3 4 5 6 7
three numbers 8 9 10
;
run;


Through this dataset i want output dataset have variable name " Number" it have values like 

1

2

3

4

5

6

7

8

9

10


like this only...

Please anyone help us to this programme

[PeterClemmensen · Accepted solution]

Like this?

data want(keep=w);
    set stansys;
    do i = 1 to  countw(string);
        w = scan(string, i);
        if prxmatch('/\b\d+\b/', w) then output;
    end;
run;

Result:

w 
1 
2 
3 
4 
5 
6 
7 
8 
9 
10

[Mohan_Reddy]

Any Another type programme we have for this same question ???

[ed_sas_member]

Hi @Mohan_Reddy 

Here is another approach:

data want (keep=number);
	set stansys;
	do i=1 to countw(compress(string,"","Kd"));
		number = scan(compress(string,"","Kd"),i);
		output;
	end;
run;

[Mohan_Reddy]

Thank You Very Much 🙂