I have a 'Name' column that is pulling in some generic data sets than contain numerics. How do I create a filter that pulls out any name containing a numeric when the column is in character format? I've tried NOT CONTAINS and NOT LIKE and keep getting ERROR: LIKE operator requires character operands. Any help is appreciated. Thanks!
Not really what I was looking for, but I used the NOTANYDIGIT I found through one of the subsequent links to create a flag for the rows that contained a number and then filtered them out of the dataset. Thanks!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.