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,' ') );

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 792 views
  • 0 likes
  • 3 in conversation