topic Re: How To Seprate Character Variable and Numeric Variable in SAS Programming

How To Seprate Character Variable and Numeric Variable

SushilKumar — Thu, 21 Mar 2013 06:50:16 GMT

I Created a Dataset In a Character Variable it contains character and Numeric Value,

I want to Split character and Numeric Value

I Have a dataset which is subject and result are character variable

subject	Result
1001	20
1002	>50
1003	Positive
1004	30.5

I Want the Dataset to be

subject	Result	Numeric	Character
1001	20	20
1002	>50		>50
1003	Positive		Positive
1004	30.5	30.5

Could Any one Help Me

Re: How To Seprate Character Variable and Numeric Variable

LinusH — Thu, 21 Mar 2013 08:30:31 GMT

The easiest way (I think) is to input the value to the numeric column using best. format. If the result is missing, store the value in the character column.

You'll have some notes in the log about invalid arguments to the input function, but that is expected.

Re: How To Seprate Character Variable and Numeric Variable

RichardinOz — Thu, 21 Mar 2013 08:39:47 GMT

Warning messages can be suppressed using ??

Numeric = input(result, ?? best.) ;

If numeric = . then character = result ;

Richard

Re: How To Seprate Character Variable and Numeric Variable

LinusH — Thu, 21 Mar 2013 08:47:38 GMT

Forgot that:smileyblush:.

Works only if you are using the data step, not in SQL.

Re: How To Seprate Character Variable and Numeric Variable

FabienLACREUSE — Thu, 21 Mar 2013 09:43:50 GMT

Dear

I very simple way

data x; length Result$ 20;
Result='20';output;
Result='>50';output;
Result='123Position';output;
Result='.';output;
Result='.23';output;

run;

data x; set x; v=(verify(Result,'1234567890.'))-1;l=length(trim(result));
length Numeric 8. CHARACTER $20;
if v=l then NUMERIC=result;
else CHARACTER=result;
run;

You can also investigaute into Regular expression, if you have some experience.

Re: How To Seprate Character Variable and Numeric Variable

RichardinOz — Thu, 21 Mar 2013 13:18:39 GMT

In my recollection proc SQL the input function does not generate warning messages in this situation, so the ?? is not necessary anyway. The OP can use SQL to achieve the same result but in this instance a data step is the simplest solution.

Richard

Re: How To Seprate Character Variable and Numeric Variable

SushilKumar — Fri, 22 Mar 2013 07:53:27 GMT

Could You write the Code

Re: How To Seprate Character Variable and Numeric Variable

RichardinOz — Fri, 22 Mar 2013 09:52:43 GMT

The code is in my reply.

You need to add a data statement, a set statement, and a run statement at the end.

Richard

Re: How To Seprate Character Variable and Numeric Variable

Haikuo — Fri, 22 Mar 2013 15:31:11 GMT

Your method works if there is no other special scenarios, such as scientific notations, for example "12E4". You maybe able to exhaust all of the possibilities, but the best practice is to let SAS to worry about it. I vote for Richard's solution.

Haikuo