Extract word after

librasonali — Fri, 04 Dec 2020 13:44:36 GMT

data Extract;
length Subjects $40;
input Subjects $;
cards;

Archaeology
Architecture and Built Environment
Art and Design
Classics and Ancient History
English Language and Literature
History
Linguistics
Modern Languages
Performing Arts
Philosophy
Theology, Divinity and Religious Studies
;
run;

Hello,

Please find abv sample data . where output should be in a new field method2 be as below .

I am confused that do I have to use substring and scan ? but how that I am confused .

method2

Built Environment

Design

Ancient History

Literature

Religious Studies

Thanks in advance ! 🙂

Re: Extract word after

Ksharp — Fri, 04 Dec 2020 14:00:10 GMT

data Extract;
input Subjects $40.;

p=findw(Subjects,'and');
if p then want=substr(Subjects,p+4);

cards;

Archaeology
Architecture and Built Environment
Art and Design
Classics and Ancient History
English Language and Literature
History
Linguistics
Modern Languages
Performing Arts
Philosophy
Theology, Divinity and Religious Studies
;
run;

topic Extract word after in SAS Programming

Extract word after

Re: Extract word after