delete missing/null blanks if numeric and text

[podarum]

I have a variable in a text format..But it contains both numeric formats and text.  I want to find out how many in that field are missing or blanks or null, regardless if they are ibn text format or numeric.  If I use the is not missing and is not null, I also lose the numeric values in that field.  Thanks

HAVE:

VAR1

abcd

dget

hfok

.

2343

/

jdio

4589

WANT:

abcd

dget

hfok

2343

/

jdio

4589

[art297]

I probably don't understand what you are asking.  For your example, not missing would suffice.  e.g.:

data have;

  infile cards truncover;

  input VAR1 $;

  cards;

abcd

dget

hfok

.

2343

/

jdio

4589

;

data want;

  set have;

  if not missing(var1);

run;

[Ksharp]

You can get it by enumerate the missing value you treat as missing value.

data have;
  infile cards truncover;
  input VAR1 $char8.;
  cards;
abcd
dget
hfok
.
2343
/
 
 
jdio
4589
;

 

data want;
  set have;
  if left(var1) in ('.' ' ') then delete;
run;

Ksharp