Hello all,
I have a problem. I have a column address where I have to put blank the rows that contain ONLY numeric variables. Example: the ones that I have highlighted
Any idea how I can proceed?
I cannot use compress because it will remove all other numeric characters from rows that contain both numeric and alphabetical
Try:
if anyalpha(var) = 0 then var = ' ';
Thank you !! It works 🙂
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.