topic Need to Create y in Administration and Deployment

Need to Create y

sainamit — Wed, 25 Sep 2013 01:58:08 GMT

Hi ,

I have a variable x. It contains string like

02p wed ssd values having alpha numeric

people having rty ers that udf

they have edf 234 bcd fgh

I need to Create y

02p wed ssd

rty ers udf

edf 234 bcd fgh

I need to pull length of 3 from the given string.

Can any once help me out on this.

Thanks,

sai

Scott_Mitchell — Wed, 25 Sep 2013 03:04:03 GMT

How about the following?

DATA WANT;

SET HAVE;

LENGTH Y $200 DONE 3;

DO I = 1 BY 1 UNTIL (DONE);

Y1 = SCAN(X,I);

IF LENGTH(Y1) = 3 THEN Y = CATX(' ',Y,Y1);

IF Y1 = '' THEN DONE = 1;

END;

DROP Y1 DONE;

RUN;

Haikuo — Wed, 25 Sep 2013 21:51:50 GMT

You can also try PRX:

data x;

infile cards truncover;

input var $200.;

cards;

02p wed ssd values having alpha numeric

people having rty ers that udf 34

they have edf 234 bcd fgh t

;

data y;

set x;

new_var=prxchange('s/(\b[0-9a-zA-Z]{4,}\b)|(\b[0-9a-zA-Z]{1,2}\b)//i',-1, var);

run;

Haikuo