What dataset looks like now: ItemNumber Description ItemType 1 Double Flatbread | <blank> with chicken 2 Regular Bacon ... | Sandwich 3 Regular Turkey/Ham | Sandwich - There are also ItemTypes such as salads, chips, cookies, add ons etc. but I am only testing sandwiches right now. Example of what output dataset should look like: ItemNumber Description ItemType 1 Double Flatbread Sandwich with chicken etc. Test Code (doesn't work): DATA Work.TestData; SET Work.TestData; IF Item_Type = '' then DO; IF FINDW(Description, 'Flatbread')>0 then Item_Type = 'Sandwich'; END; RUN; The last forum I found the FINDW command was not very helpful in explaining the structure of it so I don't know if I even started doing it correctly. Thank you for the help, if there is more code or data that you need to see I can get it.
... View more