topic Re: How to extract only character values from a mixed variable list(num+char) in sas in SAS Programming

How to extract only numeric observations from a mixed variable list(num+char) in sas

annypanny — Mon, 27 Apr 2020 11:01:17 GMT

In a dataset there is a varible list where numeric as well as character values are there, how can I get only numeric observations from it in sas. example dataline are here:in only one variable list VAR1 there are values e.g:

variable name:

VAR

................

observations:

123_854

xyz

456_672

abc

789_458

frf

233_562

gth

....

qxd

345_672

I have to extract only that numeric values e.g(233_562 etc) from that whole dataline, How can I get that.

edited. Previously it was solved

Re: How to extract only character values from a mixed variable list(num+char) in sas

PeterClemmensen — Mon, 16 Mar 2020 07:13:44 GMT

@annypanny Welcome to the SAS Community 🙂

Are these eight separate variables or one variable with eight values in it?

Re: How to extract only character values from a mixed variable list(num+char) in sas

Kurt_Bremser — Mon, 16 Mar 2020 07:14:34 GMT

Are these values stored in a single variable, or in separate variables within a given observation?

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:16:06 GMT

there is one variable and there are many values, I have just written eight values here. Thanks

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:16:32 GMT

there is one variable and there are many values, I have just written eight values here. Thanks

Re: How to extract only character values from a mixed variable list(num+char) in sas

PeterClemmensen — Mon, 16 Mar 2020 07:34:40 GMT

Does that mean you want to get rid of the commas as well? If so

data _null_;
    var1 = '123, xyz, 456, abc, 789, frf, 233, gth';
    var2 = compbl(compress(var1, '', 'ka'));
    put var2=;
run;

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:37:47 GMT

what if VAR1 has more than thousand values not eight values, then what can I do? Thanks in advance

Re: How to extract only character values from a mixed variable list(num+char) in sas

ed_sas_member — Mon, 16 Mar 2020 07:41:04 GMT

Hi @annypanny

I am a bit confused:

are our input data like this:

data have;
    var1 = '123, xyz, 456, abc, 789, frf, 233, gth';
run;

or like this?

data have;
	input VAR1 $;
	datalines;
123
xyz
456
abc
789
frf
233
gth
;
run;

In the second case, you can use the following code to output only observation containing numbers:

data want;
	set have;
	if prxmatch('/\d+\s*$/',VAR1)>0 then output;
run;

Best,

Re: How to extract only character values from a mixed variable list(num+char) in sas

PeterClemmensen — Mon, 16 Mar 2020 07:39:32 GMT

The number of values does not matter. See this

data _null_;
    var1 = '123, xyz, 456, abc, 789, frf, 233, gth,
            123, xyz, 456, abc, 789, frf, 233, gth,
            123, xyz, 456, abc, 789, frf, 233, gth,
            123, xyz, 456, abc, 789, frf, 233, gth,
            123, xyz, 456, abc, 789, frf, 233, gth';
    var2 = compbl(compress(var1, '', 'ka'));
    put var2;
run;

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:44:15 GMT

the second one is the case and I want to extract only character values.

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:44:57 GMT

there is no commas in that dataset, sorry for my previous mistake

Re: How to extract only character values from a mixed variable list(num+char) in sas

ed_sas_member — Mon, 16 Mar 2020 07:45:25 GMT

Hi @annypanny

So you can do this:

data want;
	set have;
	if prxmatch('/\d+\s*$/',VAR1)>0 then delete;
run;
proc print;

Best,

Re: How to extract only character values from a mixed variable list(num+char) in sas

PeterClemmensen — Mon, 16 Mar 2020 07:45:46 GMT

Does not matter either. My code returns the same result, commas or not.

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 16 Mar 2020 07:52:04 GMT

thanks, It is working now

Re: How to extract only character values from a mixed variable list(num+char) in sas

ed_sas_member — Mon, 16 Mar 2020 07:53:03 GMT

Awesome!

You're welcome @annypanny

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 27 Apr 2020 10:48:11 GMT

and how we can do the vice versa i.e., how to extract a only numeric character which can also contain special characters like "_". example 1234_4567 in the above question

Re: How to extract only character values from a mixed variable list(num+char) in sas

annypanny — Mon, 27 Apr 2020 11:06:17 GMT

this act as a solution for me thanks