topic Re: How to separate the first two words in New SAS User

How to separate the first two words

Aayushi_17 — Fri, 23 Oct 2020 06:17:33 GMT

Hi i want to separate first two words in the following row

Input looks like this		This how the output should be populated
Group	-->	Group
Event manager	-->	Event manager
Progression team	-->	Progression team
Disease progressed due to the following	-->	Disease progressed
Descriptive subject line	-->	Descriptive subject

thanks in advance.

Amir — Fri, 23 Oct 2020 08:03:56 GMT

Please share the SAS code you have tried, using the "Insert SAS Code" icon and any relevant log sections, using the "Insert Code" icon.

Have you tried looking into the scan() function? A link to the scan() documentation can be found here.

Kind regards,

Amir.

Ksharp — Fri, 23 Oct 2020 10:55:59 GMT

if delimiter is just a blank , that is easy.

want=catx(' ', scan(have,1,' ') , scan(have,2,' ') );