Hi SAS community pros! I am trying to create a data step and/or macro that will parse a large amount of text into individual words for further analysis. I would like to give SAS a data set with text strings in one variable, and have it return one new variable with all the words from the input variable as separate observations and removing common (or specified list of) delimiters. I have been experimenting with the SCAN function, but have not had training in how to execute loops or macro array variables. For example, please see the below excel screenshot for a simplistic example. Would like to start with SAS data set column A only, and return SAS data set columns A and B Thank you for your assistance!
... View more