topic Re: How to remove only letters in a column in SAS Programming

How to remove only letters in a column

MILKYLOVE — Tue, 15 Nov 2022 10:00:45 GMT

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

Re: How to remove only letters in a column

andreas_lds — Tue, 15 Nov 2022 10:29:34 GMT

Try:

if anyalpha(var) = 0 then var = ' ';

Re: How to remove only letters in a column

MILKYLOVE — Tue, 15 Nov 2022 11:05:05 GMT

Thank you !! It works 🙂