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))