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 🙂
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.