topic Re: Keeping only part of a variable that exists after the first space in SAS Programming

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

BenBrady — Mon, 04 Jun 2018 04:49:10 GMT

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?

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

mahesh146 — Mon, 04 Jun 2018 05:46:00 GMT

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;

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

novinosrin — Mon, 04 Jun 2018 13:49:35 GMT

@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;