topic Re: How To Re arrange numbers in row wise ??? in SAS Programming

How To Re arrange numbers in row wise ???

Mohan_Reddy — Thu, 27 Feb 2020 07:55:10 GMT

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

Re: How To Re arrange numbers in row wise ???

PeterClemmensen — Thu, 27 Feb 2020 08:15:22 GMT

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:

Re: How To Re arrange numbers in row wise ???

Mohan_Reddy — Thu, 27 Feb 2020 08:21:32 GMT

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

Re: How To Re arrange numbers in row wise ???

ed_sas_member — Thu, 27 Feb 2020 10:01:31 GMT

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;

Re: How To Re arrange numbers in row wise ???

Mohan_Reddy — Thu, 27 Feb 2020 10:08:07 GMT

Thank You Very Much 🙂