topic Delete from all rows in column X the value "Team" in SAS Programming

Delete from all rows in column X the value "Team"

Ronein — Mon, 19 Aug 2019 06:27:42 GMT

Hello

I have a data set that all values in column x start with "Team" value.

Task: Delete from all rows in column X the value "Team"

Existing values:

Team 2-5
Team 7-8
Team 9-11

New values should be:

2-5
7-8
9-11

How can I do it please?

data aaa;
INFILE DATALINES DELIMITER=',' DSD;
input x1 $;
cards;
Team 2-5
Team 7-8
Team 9-11
;
run;

PeterClemmensen — Mon, 19 Aug 2019 06:29:12 GMT

One way

data have;
input x $20.;
datalines;
Team 2-5
Team 7-8
Team 9-11
;

data want;
    set have;
    newx=tranwrd(x, 'Team ', '');
run;

Shmuel — Mon, 19 Aug 2019 08:19:23 GMT

Alternatively you can use

newx = scan(x,2,' ');