Keeping only part of a variable that exists after the first space

[BenBrady]

I have the following data:

Sports

11 Foot Ball

112 Soccer and golf

2345 basketball

12 Table tennis

But I want to keep only the part after the first space. ie:

Sports

Foot Ball

Soccer and golf

basketball

Table tennis

How do I go about doing this?

[mahesh146 · Accepted solution]

Final_Col in below dataset has the target output.

DATA TEMP;
INPUT Sports $1-35;
Fst_Col= Length(Scan(STRIP(Sports),1));
Final_col= SUBSTR(Sports,Fst_col+1);
DROP Fst_Col;
CARDS;
11 Foot Ball
112 Soccer and golf
2345 basketball
12 Table tennis
;

RUN;

[novinosrin]

@BenBrady You just need one assignment

data have;
input sports $20.;
cards;
11 Foot Ball
112 Soccer and golf
2345 basketball
12 Table tennis
;

data want;
set have;
sports=substr(sports,anyspace(sports)+1);
run;