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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 420 views
  • 0 likes
  • 3 in conversation