topic Special SubStr character column in SAS Programming

Special SubStr character column

ileshem — Tue, 13 Jun 2017 22:50:12 GMT

Hello,

I want to take a column withe expresions like:

column1

+$A1234

A4567

+#A7890

A9876

and creat a new colmun that will give me only the expression startin with "A" and the number after it"

column1

A1234

A4567

A7890

A9876

I tried to us a formula substr starting with "A":

Substr(:colmun1, A, 5)

Any help will be appreciated.

Jagadishkatam — Wed, 14 Jun 2017 04:18:41 GMT

data want;
set have;

id=prxparse('/\w\d+/');

call prxsubstr(id,column1,start,length);
column2=substr(column1,start,length);
run;

kiranv_ — Tue, 13 Jun 2017 23:57:45 GMT

something like this

compress(col,'','kad')

Shmuel — Wed, 14 Jun 2017 00:09:40 GMT

If it is always starting with capital A you can use

 var = substr(var, indexc(var,'A'));

ChrisNZ — Wed, 14 Jun 2017 04:55:58 GMT

Keep everything starting at uppercase A:

data WANT;
 STR='+$A1234';
 STR1=prxchange('s/.*(A.*)/$1/',1,STR);
 putlog STR1=;
run;

ileshem — Wed, 14 Jun 2017 21:12:43 GMT

Thanks, what is "var" and indexc should be only index, right?

Shmuel — Thu, 15 Jun 2017 03:50:21 GMT

replace var with any variable name.

indexc function looks for a character (or characters) while index function looks for a string.

in this case as the list is made of one character, you can use each of the functions.