BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Aayushi_17
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User
if delimiter is just a blank , that is easy.

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

View solution in original post

2 REPLIES 2
Amir
PROC Star

Hi @Aayushi_17 ,

 

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
Super User
if delimiter is just a blank , that is easy.

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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 856 views
  • 0 likes
  • 3 in conversation