topic Re: Splitting a string variable into two variables if a letter is present in SAS Programming

Splitting a string variable into two variables if a letter is present

MikeBurton — Mon, 04 Sep 2017 13:55:02 GMT

I have a string variable that contains numeric values and alphanumeric values. For instance:

var1

123

B23

3244

V190

I want:

var1 var2

123 .

. B23

3244 .

. V190

is there anyway to do this in SAS?

Re: Splitting a string variable into two variables if a letter is present

Miracle — Mon, 04 Sep 2017 14:08:52 GMT

something like this?

data have;
input var1 $ @@;
datalines;
123 B23 3244 V190
;
run;
data want; 
	set have;
	if anyalpha(var1)>0 then do; var2=var1; call missing(var1); end;
run;
proc print data=want noobs; run;

Re: Splitting a string variable into two variables if a letter is present

PeterClemmensen — Mon, 04 Sep 2017 14:20:00 GMT

Is the letter always the first character of the string?

Re: Splitting a string variable into two variables if a letter is present

MikeBurton — Mon, 04 Sep 2017 14:38:38 GMT

Thanks Wong,

This code worked for what I wanted.

Re: Splitting a string variable into two variables if a letter is present

Patrick — Mon, 04 Sep 2017 21:34:30 GMT

@MikeBurton

Then please mark the question as answered.