Help using Base SAS procedures

delete missing/null blanks if numeric and text

Reply
Super Contributor
Posts: 395

delete missing/null blanks if numeric and text

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

PROC Star
Posts: 7,363

delete missing/null blanks if numeric and text

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;

Super User
Posts: 9,681

delete missing/null blanks if numeric and text

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

Ask a Question
Discussion stats
  • 2 replies
  • 153 views
  • 0 likes
  • 3 in conversation