Desktop productivity for business analysts and programmers

Extracting multiple words from string

Reply
Occasional Contributor
Posts: 16

Extracting multiple words from string

Hi, I'm looking to extract multiple words from a longer string for the purposes of text mining. At the moment, all I can think of would be to concatenate the output from two SCAN functions, but I was wondering if there was a simpler way?

 

Current method in PROC SQL is:

 

CAT(SCAN(string, 1),' ',SCAN(string, 2))

Super Contributor
Super Contributor
Posts: 269

Re: Extracting multiple words from string

There might be some things you can do, but we don't have a lot to work with. 

 

You have some code that smashes the first word of a string together with the second word of a string. 

 

Maybe if you supplied some dummy sample data and a little bit more about the output you want to generate, we could provide some better guidance. 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation