I'm trying to filter out certain elements within a field e.g.:   Name: Marcus, Halberstream   Where "Name" is the field and "Marchus, Halberstream" is an individual record   I'm currently using SCAN in the filter&sort section of "Create Table" in SAS DI in the following manner:   SCAN(Name,2,',')   It correctly returns "Halberstream" - the string I want to filter by - but when I put the logic in and run the table, I still see "Marcus, Halberstream" in the output table.   Any suggestions on what I may be doing wrong or a better solution? I thought about using SUBSTR except the records are of different length, and so I cannot set an arbitrary element start-stop location, but must use "," delimiter.   Regards, Soules9219 ... View more