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))
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.